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
|