View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default count entries based on criteria in a different column

Try this:

=SUMIF(M:M,"Jan",S:S)

where M is the Month column and S is the Score column.

Hope this helps.

Pete

On Jan 9, 7:22*pm, ccKennedy
wrote:
hi,
i have a large spreadsheet and would like to count the number of entries in
one column only if a different column meets criteria.
for example:
Name * * * * * * * Month * * * * * * Score
Joe * * * * * * * * * *Jan * * * * * * * * *100%
Jane * * * * * * * * *Jan * * * * * * * * * *-
John * * * * * * * * *Feb * * * * * * * * *100%

so i want to count the number of scores (not the average score) entered for
January.
i'm using the SUMPROGRAM feature elsewhere, so if there's something along
those lines i'm not thinking about, pls help! *
thanks