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. |
#2
|
|||
|
|||
=SUMPRODUCT(--(A1:A100<
-- HTH RP (remove nothere from the email address if mailing direct) "SueC" wrote in message ... 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. |
#3
|
|||
|
|||
Try again
=SUMPRODUCT(--(A1:A100=0),--(A1:A100<6),B1:B100) or =SUMIF(A1:A100,"=0",B1:B100) - SUMIF(A1:A100,"=6",B1:B100) etc. -- HTH RP (remove nothere from the email address if mailing direct) "SueC" wrote in message ... 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. |
Reply |
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) |