| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculate the sum of cells where values are between 6 and 10 in e.
Office 2003
In the example below I would like to calculate the sum of all values which are in these catergories: 0-5, 6-10 and 11-15. eg: value age 5 4 55 5 41 10 1 15 2 4 5 5 I have used =SUMIF(b2:b25, "<6", a2:a25) for the first catergory. I'm stuck on the second catergory. Please can someone help me with this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| How do I calculate ratios between 2 cells? | Excel Discussion (Misc queries) | |||
| How do you calculate the difference between two values within a p. | Excel Discussion (Misc queries) | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
| How to add a button to restore all altered cells original values? | Excel Discussion (Misc queries) | |||
Threaded Mode
