|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 23rd, 2009, 07:34 PM
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
December 23rd, 2009, 07:39 PM
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
December 23rd, 2009, 09:01 PM
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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
