<div>
Hello Loumik,<br />
<br />
to achieve what you want you need this formula<br />
<br />
=SUMPRODUCT(COUNTIF(INDIRE<wbr />CT(&quot;Sheet&quot;<wbr /> &amp;&nbsp;ROW($1:$3) &amp;&nbsp;&quot;!<br />
A1:B5&quot;),&quot;=C&quot;))<br />
<br />
HAGD:O)Bruintje
</div>


Hello Loumik,

to achieve what you want you need this formula

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

HAGD:O)Bruintje

<div>
loumik: <br />
This old question needs to be finalized -- accept an answer, split points, or get a refund. &nbsp;For information on your options, please click here-&gt; <a href="http:/help/closing.jsp#1" rel="ugc">http:/help/closing.jsp#1</a>&nbsp;<br />
EXPERTS:<br />
Post your closing recommendations! &nbsp;No comment means you don't care.
</div>


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 [http:/help/closing.jsp#1] 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.

<div>
++++++++++++++++++++++++++<wbr />++++++++++<wbr />++++++++++<wbr />++++++++++<wbr />++++++++++<wbr />++<br />
No comment has been added lately, so it's time to clean up this TA.<br />
I will leave a recommendation in the Cleanup topic area that this question is:<br />
<br />
Accept bruintje's comment as answer<br />
<br />
<br />
Please leave any comments here within the next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!<br />
<br />
MASQUERAID<br />
EE Cleanup Volunteer - Applications<br />

</div>


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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


<div>
<div class="content wysiwyg-content">
I need to inspect a &quot;3d&quot; range of cells using the Count.If function in the following way:<br />
COUNT.IF(Sheet1:Sheet3!A1:<wbr />B7;&quot;C&quot;)<br />
I always get an error message in the cell.<br />
I tried to inspect a &quot;2d&quot; range and the function works well<br />
What is the problem? Is this function unable to process<br />
&quot;3d&quot; ranges?<br />
Is there another way to do it?<br />
Thank you.<br />
&nbsp; 
</div>
</div>


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.
  

Count.if function in Excel 97

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.