Try putting =NA() into one of the cells in the range... the formula
evaluates to #NA, probably because SUMPRODUCT attempts to multiply the #N/A
by 0 for cells containing #N/A, which it cannot do.

--
Rick (MVP - Excel)


"Joel" wrote in message
...
Why wouldn't it work?

"T. Valko" wrote:

=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?