COUNT IF.... Feature, please help ASAP
 

Does anyone out there know if it is possible to have the count if feature can
retrieve and count data from more than column, ie; I want it to count all of
my X data in column A and then out of all of those X's in column, how many of
those belong to Y in column C. Thanks greatly appreciated, this is for a
major spreadhseet I'm producing for work and I want to impress my boss. BR

Hi,

Use

=SUMPRODUCT(($A$2:$A$7="X")*(C2:C7="Y"))

Regards

Govind.

Count If wrote:
Does anyone out there know if it is possible to have the count if feature can
retrieve and count data from more than column, ie; I want it to count all of
my X data in column A and then out of all of those X's in column, how many of
those belong to Y in column C. Thanks greatly appreciated, this is for a
major spreadhseet I'm producing for work and I want to impress my boss. BR

Thanks a bunch. I was so excited to get a response.

Me and my boss are trying this, but we are off by 1 on every example we've
tried.

Any suggestions?

"Govind" wrote:

Hi,

Use

=SUMPRODUCT(($A$2:$A$7="X")*(C2:C7="Y"))

Regards

Govind.

Count If wrote:
Does anyone out there know if it is possible to have the count if feature can
retrieve and count data from more than column, ie; I want it to count all of
my X data in column A and then out of all of those X's in column, how many of
those belong to Y in column C. Thanks greatly appreciated, this is for a
major spreadhseet I'm producing for work and I want to impress my boss. BR

Post your formula, and the ranges you're using, together with their content.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Count If" wrote in message
...
Thanks a bunch. I was so excited to get a response.

Me and my boss are trying this, but we are off by 1 on every example we've
tried.

Any suggestions?

"Govind" wrote:

Hi,

Use

=SUMPRODUCT(($A$2:$A$7="X")*(C2:C7="Y"))

Regards

Govind.

Count If wrote:
Does anyone out there know if it is possible to have the count if
feature can
retrieve and count data from more than column, ie; I want it to count
all of
my X data in column A and then out of all of those X's in column, how
many of
those belong to Y in column C. Thanks greatly appreciated, this is
for a
major spreadhseet I'm producing for work and I want to impress my
boss. BR