Excel is very bad when it comes to 3D functionality

Here is a way of bypassing that

http://www.mcgimpsey.com/excel/threedsumif.html


note that unless you use the add-in morefunc you would need to create a list
of all the sheet names in question

--


Regards,


Peo Sjoblom

"Countif error" <Countif wrote in message
...
I am trying to count the occurence of text that appear within a 12 month
rolling report. When i enter the criteria and the range I come up with the
error #REF or #Value. I have tried the SUM(IF('January 2008:June
2008'!$B$4:$B$10,"Mindset/Intentions")) and the countif formula, but I
still
receive the same error message