3D Sumproduct with error handling

[Atom]

I found this method of summing a range across sheets:
=SUMPRODUCT(SUMIF(INDIRECT("'"&sheets&"'!"&"rng"),criteria,INDIRECT("'"&sheets&"'!"&"sumrng")))

I'd like to use this to be able to handle summing a 3D range with an error value in the range to be summed such that the error value is ignored

[XLent]

I suspect you want to go SUMIFS route - depending on how many different error values you might find it easier to use numerics as a criteria, e,g.

Please Login or Register  to view this content.

if you need to account for both positive + negative numbers you can use the below

Please Login or Register  to view this content.

however, it's worth noting that given you're using the above w/SUMPRODUCT and in Volatile context (c/o INDIRECT) this will be slower (doing 2 SUMIFS for each tab).