count entries based on criteria in a different column
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 |
count entries based on criteria in a different column
Not sure what SUMPROGRAM is, did you mean SUMPRODUCT? Try something like:
=SUMPRODUCT(--(B1:B10="Jan"),--(C1:C10<"")) HTH Elkar "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 |
count entries based on criteria in a different column
Thank you!!! worked Brilliantly.
(yes, oops, i did mean product, thanks!) "Elkar" wrote: Not sure what SUMPROGRAM is, did you mean SUMPRODUCT? Try something like: =SUMPRODUCT(--(B1:B10="Jan"),--(C1:C10<"")) HTH Elkar "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 |
All times are GMT +1. The time now is 12:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com