Need help with counting

[Sean15]

Excel 2010
	B	C	D
2	Age	Count
3	12	15
4	14	16
5	17	10
6	21	56
7	25	9
8
9
10	Age	Count
11	12-17	41
12	21-25	65
Sheet1

Hello:

Can you guide me how to get a count in C11 and C12 using formula.

I also tried using a pivot table but can't figure out how to make it work.

Thank you very much

Sean

 

[FDibbins]

You need to split the ranges and put them in their own cells - then you can use SUMifS()

 

[FDibbins]

If you are unable (or unwilling) yo break out the ranges, try this...
=SUMIFS($C$3:$C$7,$B$3:$B$7,">="&LEFT(B11,2),$B$3:$B$7,"<="&RIGHT(B11,2))

 

[Sean15]

Thank you very much

Sean