| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formula, counting one criteria in a range based on ano
I have two columns of data, one being gender and the other being nationality.
I want to count how many British males there are, I can get the formulas to work. I have tried many many variations of counta, countif, countifs, if etc and none work.....where am I going wrong! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula, counting one criteria in a range based on ano
Hi,
Try this =SUMPRODUCT((A1:A24="Male")*(B1:B24="British")) Mike "sarahlbdarling" wrote: I have two columns of data, one being gender and the other being nationality. I want to count how many British males there are, I can get the formulas to work. I have tried many many variations of counta, countif, countifs, if etc and none work.....where am I going wrong! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula, counting one criteria in a range based on ano
For XL2007:
=COUNTIFS(A1:A100,"Male",B1:B100,"British") "sarahlbdarling" wrote: I have two columns of data, one being gender and the other being nationality. I want to count how many British males there are, I can get the formulas to work. I have tried many many variations of counta, countif, countifs, if etc and none work.....where am I going wrong! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional Formula, counting one criteria in a range based on ano
Hi,
using reference cells: =SUMPRODUCT(--(A1:A10=D1),--(B1:b10=D2)) Where D1 contains Male and D2 contains British. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "sarahlbdarling" wrote: I have two columns of data, one being gender and the other being nationality. I want to count how many British males there are, I can get the formulas to work. I have tried many many variations of counta, countif, countifs, if etc and none work.....where am I going wrong! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting dates based on certain criteria | Excel Worksheet Functions | |||
| Function - counting based on criteria | Excel Worksheet Functions | |||
| counting occurences based on two criteria | Excel Discussion (Misc queries) | |||
| conditional formula - based on 2 separate criteria | Excel Worksheet Functions | |||
| counting based on criteria | Excel Worksheet Functions | |||
Linear Mode
