calculate the sum of cells where values are between 6 and 10 in e.

[SueC]

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.

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A100<

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

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)