| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count criteria within a set range in excel
Hello
Hopefully some kind person can assist with this. I have a worksheet with n number of rows (can vary from 30 to 3000) and columns from a to m (13). I need to count the number of times that column L value exceeds 120 when column E = a pre defined value. This pre defined value can equal 320, 744, 743, 73H and many more. I have a table set up that has these required "pre defined values". Keep in mind that this table is dynamic, values can be added or deleted. The reference for this table is on another worksheet "table" A1..A15. I don't mind where this table is located, it just happens to be in this seperate worksheet. I can sort or filter however I was wondering if there was a better way to count the occurrences. Many thanks Regards Allan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using A Cell In Excel as Criteria for a Query | Excel Discussion (Misc queries) | |||
| Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Excel Worksheet Functions | |||
| How do I count items within a date range in Excel? | Excel Worksheet Functions | |||
| Can Excel count the number of scores within a range? | Excel Worksheet Functions | |||
| How do I count data in range A:A that is dependent upon criteria . | Excel Worksheet Functions | |||
Threaded Mode
