It doesn't work because you're trying to multiply values=20
with errors. If A3 were #N/A, you get:

=3D{TRUE;TRUE;FALSE;TRUE;TRUE}*{3;4;#N/A;3;2}

which produces

{3;4;#N/A;3;2}

Trying to perform an operation (add,multiply,etc.) on an=20
error value only returns another error. Aladin's formula=20
simply ignores #N/A, while Leo's converts those error=20
values to 0.

HTH
Jason
Atlanta, GA

-----Original Message-----
Why doesn't:
=3DSUMPRODUCT((ISNUMBER(A1:A5))*(A1:A5))
work?
It still produces #N/A
TIA,


"Aladin Akyurek" wrote in message
...
=3DSUMIF(Range,"<#N/A")

Ren=E9 wrote:
I have a table where I lookup working hours in=20
a "Incident reporting
sheet"
I want to sum these hours per week. Some of the=20
cells are invalid
(#N/A),
because there were no incidents that day. But then I=20
can't get the sum
for
those specific weeks. How do I ignore the invalid=20
cells in summing those
arrays?


.