| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing a range within a range
I need the formula that will sum a range within a range. Example: the primary
range consists of the following numbers: 1,2,3,4,5,6,7,8,9,10 and I need to know how many numbers are 3 and <8. First I need to know the sum ot the qualifying numbers; second I need to know how many items there are. Stumped and exhausted...anyone's help will be greatly appreciated! -- Need to Know |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing a range of cells based on criteria in another range | Excel Worksheet Functions | |||
| Summing a Range With N/A's | Excel Discussion (Misc queries) | |||
| Summing between Range | Excel Discussion (Misc queries) | |||
| Summing range that contains text | Excel Worksheet Functions | |||
| Summing a range that changes | Excel Discussion (Misc queries) | |||
Threaded Mode
