| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| create total from 4 seperate worksheets | Excel Discussion (Misc queries) | |||
| Adding a Single Cell total from Seperate sheets | Excel Worksheet Functions | |||
Hybrid Mode
