How to calculate SUMIF with value between?

[Peter888]

Hi i would like to know how to use SUMIF formula with between values in it. For example i have citizen age database, i want to calculate number of citizen aged between 10 and 17. What formula should i use to get 7 Person as result ? Please let me know the solution. Thank you !

 

[Phuoc]

Book1
	A	B	C	D
1
2	15	4		7
3	24	3
4	21	2
5	16	3
6	8	5
Sheet1

Cell Formulas
Range	Formula
D2	D2	=SUMIFS(B2:B6,A2:A6,">="&10,A2:A6,"<="&17)

 

[Saurabhj]

Hi, use below formula

=SUMIFS($B$2:$B$6,$A$2:$A$6,">=10",$A$2:$A$6,"<=17")

SUMIF.xlsx
	A	B	C	D	E
1	Age	No of Citizen
2	15	4
3	24	3		No of Citizen	7
4	21	2
5	16	3
6	8	5
7
8
9
Sheet1

Cell Formulas
Range	Formula
E3	E3	=SUMIFS($B$2:$B$6,$A$2:$A$6,">=10",$A$2:$A$6,"<=17")

 

[Toadstool]

Hi Peter888,

You'll need to use SUMIFS as there are two conditions: Greater than or equal to 10 and less than or equal to 17.

Peter888.xlsx
	A	B	C	D
1	Age	Number of Citizens		Result
2	15	4		7
3	24	3
4	21	2
5	16	3
6	8	5
Sheet1

Cell Formulas
Range	Formula
D2	D2	=SUMIFS(B2:B6,A2:A6,">="&10,A2:A6,"<="&17)

 

[Peter888]

I tried every solution but it does return #VALUE!. Is there something wrong with it?

 

[Peter888]

Never mind guys. All worked. Thank you everyone!