Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding data in a list that meets a specific criteria
Hi
I have a long column of data in descending order. I want to add up all the data that fits a specific criteria e.g. all data below 10, then all data between 10 and 20 etc etc. I have to repeat this often and the data set changes regularly so I need to use a function rather than set ranges. Any ideas?? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up data in multiple cells for a single criteria. | Excel Worksheet Functions | |||
Averaging data that meets a criteria | Excel Worksheet Functions | |||
Retrieving a Value from List that meets multiple Criteria | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
data validation list should have opt. to select based on criteria | Excel Worksheet Functions |