Just want to throw this out there. I am referencing three rather large sheets and trying to bring in some COUNTIF data but keep getting told that I am referencing too many cells. This is prohibiting me from creating the data I need.
It would be great if you could do cross-sheet references from reports. This would allow me to filter-down the data I need before I actually do the reference, therefore linking fewer cells.
Submit a product enhancement request with me if you think its a good idea!