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 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 ExcelNext: 2 rows of information, need to move to 1 row