ExcelBanter - finding total from 2 seperate columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - finding total from 2 seperate columns (https://www.excelbanter.com/excel-worksheet-functions/174598-finding-total-2-seperate-columns.html)

Rob

finding total from 2 seperate columns

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

Teethless mama

finding total from 2 seperate columns

=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

Mike H

finding total from 2 seperate columns

You should be able to work the other out

=SUMPRODUCT((A1:A10="m")*(B1:B10=198))

Mike

"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

All times are GMT +1. The time now is 11:31 PM.