Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel count with 2 conditions
I'm sure this is an easy one for you but I just can't get it to work
correctly. I have a spreadsheet that I want to count certain criteria. Example: A B C Name Gender Score Calvin M 3 William M 4 Jessica F 1 Sarah F 3 Bryan M 1 Anna F 3 I need to how many females scored a 3. What would you suggest I use for a formula? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel count with 2 conditions
=SUMPRODUCT(--(B1:B6="F")*(C1:C6=3))
"janet" wrote: I'm sure this is an easy one for you but I just can't get it to work correctly. I have a spreadsheet that I want to count certain criteria. Example: A B C Name Gender Score Calvin M 3 William M 4 Jessica F 1 Sarah F 3 Bryan M 1 Anna F 3 I need to how many females scored a 3. What would you suggest I use for a formula? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel count with 2 conditions
On Dec 23, 2:39*pm, Mike wrote:
=SUMPRODUCT(--(B1:B6="F")*(C1:C6=3)) "janet" wrote: I'm sure this is an easy one for you but I just can't get it to work correctly. *I have a spreadsheet that I want to count certain criteria. * Example: * *A * * * * * B * * * * * *C Name * * *Gender * * Score Calvin * * * M * * * * * *3 William * * M * * * * * *4 Jessica * * *F * * * * * *1 Sarah * * * F * * * * * * 3 Bryan * * * *M * * * * * *1 Anna * * * * F * * * * * * 3 I need to how many females scored a 3. *What would you suggest I use for a formula? * Just curious, what does the "--" in the formula do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count rows that meet 2 conditions in Excel 2007 | Excel Worksheet Functions | |||
Excel 2003 count if multple conditions apply | Excel Worksheet Functions | |||
COUNT IF - 2 conditions | Excel Discussion (Misc queries) | |||
How Do I have excel count 2 cells with conditions (Excel 2003) | New Users to Excel | |||
Count function in excel with different conditions | Excel Worksheet Functions |