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