Counting values in one cell based on values in another
Thanks Sheeloo!
"Sheeloo" wrote:
=SUMPRODUCT(--(A1:A50=1),--(B1:B50="X"))
will give you what you what you want. Change 50 to the last row of your
data...
You can also try in E1
=SUMPRODUCT(--(A1:A50=C1),--(B1:B50=D1))
with 1 in C1, and X in D1
|