How do I count my data that are between specific values?
 

I have a column on sheet1! that gives ages of clients
A
5
59
12
22
33
17
6
18
I want to calculate totals for clients in the age range of 5-12,13-17, and
18+.
I tried using a sumproduct and sum if and neither is working

One way

=SUMIF(B1:B10,"<=12",C1:C10)-SUMIF(B1:B10,"<5",C1:C10)

=SUMIF(B1:B10,"<=17",C1:C10)-SUMIF(B1:B10,"<13",C1:C10)

=SUM(C1:C10)-SUMIF(B1:B10,"<17",C1:C10)

Regards

Trevor


"LDC" wrote in message
...
I have a column on sheet1! that gives ages of clients
A
5
59
12
22
33
17
6
18
I want to calculate totals for clients in the age range of 5-12,13-17, and
18+.
I tried using a sumproduct and sum if and neither is working

try
=sumproduct((rnga=5)*(rnga<13))

--
Don Guillett
SalesAid Software

"LDC" wrote in message
...
I have a column on sheet1! that gives ages of clients
A
5
59
12
22
33
17
6
18
I want to calculate totals for clients in the age range of 5-12,13-17, and
18+.
I tried using a sumproduct and sum if and neither is working

=COUNTIF(A1:A100,"=5")-COUNTIF(A1:A100,"12")



On Tue, 16 Nov 2004 14:00:03 -0800, LDC wrote:

I have a column on sheet1! that gives ages of clients
A
5
59
12
22
33
17
6
18
I want to calculate totals for clients in the age range of 5-12,13-17, and
18+.
I tried using a sumproduct and sum if and neither is working