Forum Discussion
Countif Formula returns #Value!
Hi Experts, I am working on a formula that searches a particular column in all spreadsheets (40) for a specific string. There are entries in this column that would be headers, blanks etc. Cur...
AaronJames COUNTIF and all similar functions don't work with 3D cross-sheet references. You'd have to make one formula per sheet (perhaps with the use of ADDRESS and INDIRECT).