Conditional Functions in 3D references

[Jbossa]

On excel XP. Can I use Sumif or countif in 3D references ? For example if I want to find how many instances of a value in the same cell in different worksheets is >1 How do I do that. I get a REF error or a Value error when I try.

Thanks for the help

 

[fairwinds]

Hi,

If you have only a fiew sheets you can tie them by using CHOOSE formula, else I suggest you searh this board for sollutions using THREED function from the morefunc add in. Aladin Akyurek has made several posts with that kind of sollutions.