Sum Range using a drop down menu

[DavosCH32]

I'm having a problem using the sumif formula with a drop down menu selection. I can easily get the cell value based on the drop down selection however I cannot sum the range of the cells. The Day range would be the drop down containing the last 7 days, the last 15 days, the last 30 days etc. Based on what was selected, I would need to sum that date and back. Any help would be much appreciated!

Day Range		Day Range	% Total
last 15 days		Current day	8.8%​
		1-3 days	37.9%​
Sum of Range		4-7 days	12.9%​
65.2%​		8-15 days	5.6%​
		16-30 days	3.7%​
		31-60 days	4.6%​
		61-90	1.7%​
		91+	3.7%​

 

[jtakw]

Hi,

Are you willing to make some changes to your set up like below?
Split the "Day Range" to 2 columns using Numbers Only.
Change your "Drop Down" to Numbers Only.

Book3.xlsx
	A	B	C	D	E	F
1		Day Range		Day Range From	To # Days	% Total
2	last # of days	15		0		8.80%
3				1	3	37.90%
4		Sum of Range		4	7	12.90%
5		65.20%		8	15	5.60%
6				16	30	3.70%
7				31	60	4.60%
8				61	90	1.70%
9				91		3.70%
Sheet886

Cell Formulas
Range	Formula
B5	B5	=SUMIF(D2:D9,"<="&B2,F2:F9)