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 |
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 . |
=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 . |
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 |
All times are GMT +1. The time now is 04:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com