COUNT IF.... Feature, please help ASAP

[Guest]

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

 

[Govind]

Hi,

Use

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

Regards

Govind.

 

[Guest]

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?

 

[Ragdyer]

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