Count IF?
Try one of these:
=SUMIF(F13:F38,"<1E100")
=SUMIF(F13:F38,"<#N/A")
--
Biff
Microsoft Excel MVP
"Canon" wrote in message
...
Excel 2007
I have a simple formula, =sum(F13:F38)
I have added formulas in other cells that when nothing is in the cells,
#N/A
appears in some of the cells (F13 to F18) and my above formula will no
longer
work. Is there a way to correct this formula to just add up the cells
with
numbers?
|