count entries based on criteria in a different column

  • Thread starter Thread starter ccKennedy
  • Start date Start date
C

ccKennedy

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
 
Not sure what SUMPROGRAM is, did you mean SUMPRODUCT? Try something like:

=SUMPRODUCT(--(B1:B10="Jan"),--(C1:C10<>""))

HTH
Elkar
 
Back
Top