=SUMPRODUCT(--(ISNA(F13:F38)=FALSE),F13:F38)

I don't think that works.


--
Biff
Microsoft Excel MVP


"Joel" wrote in message
...

=SUMPRODUCT(--(ISNA(F13:F38)=FALSE),F13:F38)
"Canon" wrote:

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?