Hi,

I have a filter function which sums the values from the fifth column of the returned array:

=SUM(FILTER(FILTER(Tasks!$B$34:$F$171,(Tasks!$B$34:$B$171=G$1)*(Tasks!$E$34:$E$171=$A2)), {0,0,0,0,1}))

In both of the filter functions, I have left the optional if_empty variable blank. With this value blank it returns #CALC is there is no data found, presumably due to the lower order filter function returning an empty array.

If there is matching data, the formula works as expected.

So I thought if I was to put a 0 in the if_empty location, then I would get 0 back as a result, if the filter finds nothing. As it turns out I get #VALUE instead.

I have tried putting a 0 in both or one or the other filter formalus, but the result is the same.

Does anyone have any idea how I can make the formula return a 0 if there are no results from my filter functions?

Thanks,