CountIf()

[pacoonejr]

I guess I just don't get it. I want to count on F2:F200 IF B = "Y" and F = "Z". I think (emphasis on think) I have tried every concievable way to do this. Could someone please explain this to me.

Thanks in advance.

 

[BMD]

Help I received from this board

=SUMPRODUCT(--(INDIRECT("'"&D$1&"'!$G$3:$G"&D$8)="Pass"),--(ISNUMBER(MATCH(INDIRECT("'"&D$1&"'!$I$3:$I"&D$8),{"Major","Maj"},0))))

I counting passed in column G and major in column I.
HTH,
Bruce.

 

[NBVC]

Are you looking in B1 and F1 or the Y and Z, respectively? Or are you looking in column B and Column F for occurrences of Y and Z?

 

[just_jon]

I guess I just don't get it. I want to count on F2:F200 IF B = "Y" and F = "Z". I think (emphasis on think) I have tried every concievable way to do this. Could someone please explain this to me.

Thanks in advance.

Try --

=SUMPRODUCT(--(B2:B200="Y"),--(F2:F200="Z"),F2;F200)

for counting, use

=SUMPRODUCT(--(B2:B200="Y"),--(F2:F200="Z"))

 

[pacoonejr]

SUMPRODUCT, FAR OUT! That did it. YIPEE!