Hello,

I tried to do a 3D sumif formula, but it didn't work.
=sumif(sheet1:sheet6!a1,"0") but I got a #VALUE


Does anyone have a method that can be used to get the result that I want?
And could the solution be used for the "Countif" and "Average" functions as
well?

Thanks in advance

André