Prev: Denormalized data in Excel
Next: 2 rows of information, need to move to 1 row
From: janet on 23 Dec 2009 14:34
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?
From: Mike on 23 Dec 2009 14:39
=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?
From: wx4usa on 23 Dec 2009 16:01
On Dec 23, 2:39 pm, Mike <M...(a)discussions.microsoft.com> 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?
 | 
Pages: 1
Prev: Denormalized data in Excel
Next: 2 rows of information, need to move to 1 row