| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count entries based on criteria in a different column
thank you for your reply - that is returning the average score, not the total
# of entries... "Pete_UK" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurrents based on criteria in different column | Excel Worksheet Functions | |||
| Count no. of nonblank cells in one column based on criteria of ano | Excel Discussion (Misc queries) | |||
| Count entries in one column based on values in another column | Excel Worksheet Functions | |||
| Count Non-Blanks in one column based on criteria in another | Excel Worksheet Functions | |||
| I Need to Count Number of Entries Based on Two Criteria | Excel Worksheet Functions | |||
Hybrid Mode
