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