| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I count the number of entries of specifc criteria is met
Hi,
I'm trying to count the value in one column but only if the criteria in an ajoining column is met. There are loads of columns and rows but 2 columns contain the following:- Column K contains values of 0%, 25%, 75% and 100% Column M contains values of 1, 2 or 3. I would like to count the amount of 1's that are at 25% ar 50% and 75% and 100%. I would then like to do the same for the 2's and 3's... Each result will be displayed in a different cell. E.G. Priority 0% 25% 50% 75% 100% 1 2 3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula - count Nº of entries but with other filtering criteria | New Users to Excel | |||
| count entries based on criteria in a different column | Excel Worksheet Functions | |||
| count entries based on criteria in a different column | Excel Worksheet Functions | |||
| Count of entries meeting criteria | Excel Worksheet Functions | |||
| I Need to Count Number of Entries Based on Two Criteria | Excel Worksheet Functions | |||
Threaded Mode
