Sumifs formula

[ste33uka]

I have the following formula that sums column G , if column C says red and column E is between 0 and 5,
Is there a way to change formula so it says if column E is between cells E1 and G1 ?
Thanks

Book2
	B	C	D	E	F	G	H	I
1		RED		0		5		6
2
3
4
5		RED		4		6
6		RED		9		7
7		BLUE		12		8
8
9
10
Sheet1

Cell Formulas
Range	Formula
I1	I1	=SUMIFS($G$5:$G$12,$C$5:$C$12,$C$1,$E$5:$E$12,">0",$E$5:$E$12,"<5")

 

[hrayani]

Hi, try this

=SUMIFS($G$5:$G$12,$C$5:$C$12,$C$1,$E$5:$E$12,">="&E1,$E$5:$E$12,"<="&G1)

 

[ste33uka]

Thanks alot, Thats what i was looking for

 

[hrayani]

You are welcome & thanks for the feedback