software

Hi everyone,

So my title might be the best way to answser my questionb ut I'll give
it a longer description here.

I don't want to clutter worksheetA with hidden fields containing
formulas that I would then call in WorksheetB.

So how do I tell CountIF to calculate specified cells in a different
worksheet?

Your help would be appreciative. I searched through the help file but
just simply don't know what I'd be looking for.

JJ--
jfj3rd
------------------------------------------------------------------------
jfj3rd's Profile: www.excelforum.com/member.php...oamp;userid=33503
View this thread: www.excelforum.com/showthread...hreadid=532987You could just Define a Named Range (Insert Menu -gt; Names -gt; Define). and
then the formula would refer to the Named Range instead of a range of cells.

example: =COUNTIF(myNamedRange,quot;Yesquot;)

myNamedRange could dynamically be defined by using the formula:
=OFFSET($A$1,0,0,COUNTA('Sheet1'!$A:$A),1)

This assumes the data you are wanting the COUNTIF to look at would be in
Column A, starting in Row 1. This dynamic named range will end the first
time it encounters a blank cell, though.

I hope this helps.

Rich

quot;jfj3rdquot; wrote:

gt;
gt; Hi everyone,
gt;
gt; So my title might be the best way to answser my questionb ut I'll give
gt; it a longer description here.
gt;
gt; I don't want to clutter worksheetA with hidden fields containing
gt; formulas that I would then call in WorksheetB.
gt;
gt; So how do I tell CountIF to calculate specified cells in a different
gt; worksheet?
gt;
gt; Your help would be appreciative. I searched through the help file but
gt; just simply don't know what I'd be looking for.
gt;
gt; JJ
gt;
gt;
gt; --
gt; jfj3rd
gt; ------------------------------------------------------------------------
gt; jfj3rd's Profile: www.excelforum.com/member.php...oamp;userid=33503
gt; View this thread: www.excelforum.com/showthread...hreadid=532987
gt;
gt;


Hi,

For multi criteria, take a look at sumproduct()

Cheers
Carim--
Carim
------------------------------------------------------------------------
Carim's Profile: www.excelforum.com/member.php...oamp;userid=33259
View this thread: www.excelforum.com/showthread...hreadid=532987have you not just tried

=COUNTIF('other worksheet name'!range,criteria)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;jfj3rdquot; gt; wrote in
message ...
gt;
gt; Hi everyone,
gt;
gt; So my title might be the best way to answser my questionb ut I'll give
gt; it a longer description here.
gt;
gt; I don't want to clutter worksheetA with hidden fields containing
gt; formulas that I would then call in WorksheetB.
gt;
gt; So how do I tell CountIF to calculate specified cells in a different
gt; worksheet?
gt;
gt; Your help would be appreciative. I searched through the help file but
gt; just simply don't know what I'd be looking for.
gt;
gt; JJ
gt;
gt;
gt; --
gt; jfj3rd
gt; ------------------------------------------------------------------------
gt; jfj3rd's Profile:
www.excelforum.com/member.php...oamp;userid=33503
gt; View this thread: www.excelforum.com/showthread...hreadid=532987
gt;