Count.if function in Excel 97

loumik
loumik used Ask the Experts™
on
I need to inspect a "3d" range of cells using the Count.If function in the following way:
COUNT.IF(Sheet1:Sheet3!A1:B7;"C")
I always get an error message in the cell.
I tried to inspect a "2d" range and the function works well
What is the problem? Is this function unable to process
"3d" ranges?
Is there another way to do it?
Thank you.
 
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2006

Commented:
Hello Loumik,

to achieve what you want you need this formula

=SUMPRODUCT(COUNTIF(INDIRECT("Sheet" & ROW($1:$3) & "!
A1:B5"),"=C"))

HAGD:O)Bruintje
Top Expert 2006
Commented:
and you can get a free add in that helps with these problems

http://longre.free.fr/english/
loumik:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
Most Valuable Expert 2013

Commented:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept bruintje's comment as answer


Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

MASQUERAID
EE Cleanup Volunteer - Applications

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial