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 