| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate sum between different criteria
I need to sum a range of numbers based on 2 different criteria. Example:
Col A Col B 101 5 112 10 125 5 130 20 I need to sum Col B if the numbers in Col A are between 110 & 129. The correct answer would be 15. I've tried IF, AND and nesting them but nothing is working correctly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate how many meet min and max criteria | Excel Worksheet Functions | |||
| Calculate mode based on criteria | Excel Worksheet Functions | |||
| calculate a MEDIAN using multiple criteria? | Excel Worksheet Functions | |||
| calculate the sum based on two different criteria | Excel Discussion (Misc queries) | |||
| calculate percent from multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
