Countif(and
HI
Try this : =SUMPRODUCT(--(A1:A100="X"),--(B1:B100="Y"))
Adjust range as needed.
HTH
John
"Help with Countif(and" <Help with
wrote in message ...
I'm trying count how many times the value from one cell equals those cells
in
a defined range and another cells equals the values in another defined
range.
So I want to count the number of occurences where the a cell in column
A="X"
and the cell in column B in the same row = "Y".
|