Google Sheets: 3d References

[@lostsaucestolen]

Can you do COUNTIF functions on a 3D Range? (e.g. count how many times a word appears across the same cell range in multiple sheets; I have ~30 sheets so rewriting the COUNTIF function for each sheet with 30 "+"s takes forever)

[@SpencerFarris]

I'm sure something could be programmed, but I don't have a script pre-made for that
Alternatively use QUERY with a range of sheet names

[@tanveerhussain3881]

best

[@Avi8053]

So much easier on excel though!

[@SpencerFarris]

No doubt! Hopefully Google someday introduces them natively; but for now, it can at least be done

[@adios04]

Doesn't work...

[@SpencerFarris]

Hi Aditya,
If you can explain what you've done, what's not working, etc. I'm always happy to help get my functions working with you