=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