count entries based on criteria in a different column

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
 
E

Elkar

Not sure what SUMPROGRAM is, did you mean SUMPRODUCT? Try something like:

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

HTH
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count unique with multiple criteria 3
count entries that equal one criteria if another column meets anot 7
Count Distinct Values based on criteria 4
Counting on 2 criteria 2
Counting Multiple Records by specific criteria 5
Count multiple criteria 7
How do I count the number of entries of specifc criteria is met 2
Count NonBlank Rows with Criteria in another column 5

Top