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,
Bookmarks