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

G

Guest

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
 
T

Trevor Shuttleworth

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup and count all cells that fall between 2 dates 3
how do i Count with in the cell range value is >5 and <=15 1
need a formula that has to do with dates. 1
How do I find a match for three variables to determine the result? 4
Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria 2
Count zero values before specific date 6
Count Text Values in a filterd column 5
How do I sum cells by refering to discrete values? 7

Top