Joe Gieder

Posts: n/a

SUM a column with errors

I need to sum several columns that due to formulas within the cells have a
result of #N/A. Is there a way to sum this column?
example is;
#N/A
#N/A
$8,100.00
$11,250.00
#N/A
$280.00
#N/A
TIA
Joe

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I sort by row instead of by column?	PercivalMound	Excel Worksheet Functions	7	August 28th 06 10:41 PM
Format cell in column B based on value in the next cell (column c)	Nicole	Excel Discussion (Misc queries)	7	May 18th 05 10:19 PM
Copying the contents of a column into a chart	Richard	Excel Worksheet Functions	1	November 16th 04 02:39 PM
How to calculate the data in excel 2002 including only the last 9.	TylerMaricich	Excel Worksheet Functions	6	November 8th 04 07:27 AM
Summing a Column wit errors?	Jako	Excel Worksheet Functions	4	November 1st 04 07:32 PM

All times are GMT +1. The time now is 08:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us