Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Hi!
If the values will always be positive: =SUMIF(A1:A10,"0") Or, this one covers just about everything: =SUMIF(A1:A10,"<#N/A") Biff -----Original Message----- 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 . |
#3
|
|||
|
|||
=SUMIF(A:F,"<#N/A")
HTH Jason Atlanta, GA -----Original Message----- 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 . |
#4
|
|||
|
|||
Thank you both.
"Joe Gieder" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
Copying the contents of a column into a chart | Excel Worksheet Functions | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
Summing a Column wit errors? | Excel Worksheet Functions |