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.

=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.

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.