=SUMPRODUCT(--(A2:A11="M"),--(B2:B11=198))

"Rob" wrote:

I need to have total from 2 columns. If the person is male and is 198 = 2, if
person is male and 123 = 1. if person is F and 275 = 0. I have tried countif
and sum but must be to dumb to get it. PLEASE HELP!!!!!

M 220
M 181
M 198
M 123
F 97
M 132
M 198
M 148
F 123
F 148