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
Bookmarks