Adding to Jason's note... That SumProduct formula does not filter out
the #N/A's. Filtering would require a conditional with IF. Adding such a
conditional as a term to a SumProduct formula would force us to confirm
it with control+shift+enter. In such cases, it's better to switch to an
appropriate "array" formula.

JMay wrote:
Why doesn't:
=SUMPRODUCT((ISNUMBER(A1:A5))*(A1:A5))
work?
It still produces #N/A
TIA,


"Aladin Akyurek" wrote in message
...

=SUMIF(Range,"<#N/A")

René wrote:

I have a table where I lookup working hours in a "Incident reporting

sheet"

I want to sum these hours per week. Some of the cells are invalid

(#N/A),

because there were no incidents that day. But then I can't get the sum

for

those specific weeks. How do I ignore the invalid cells in summing those
arrays?