Countif Formula returns #Value!

[AaronJames]

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.

Currently, I have the following =COUNTIF(abc:zyx!C:C,B7). My understand is that it will look through the C column on all spreadseets betwen abc and zyx inclusive and count how many times it sees the string contained in B7.

Am I missing something here?

Thanks in advance.

Aaron

[#2]

@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).