Add B1:B5 if enter 5; B1:B7 if enter 7

[skittles96]

Column A Column B
Jan 11584
Feb 11020
Mar 7577
Apr 8961
May 7040
Jun 4591
Jul 3809
Aug 4759
Sep 4736
Oct 8995
Nov 8120
Dec 11728

I'd like to create formula in column D that if I enter a "5" in C1, it SUMS B1:B5; if I enter a 7, I'd like it to SUM b1:b7 and so on.

Any thoughts.

Thanks in advance for your assistance !

 

[texasalynn]

=if(c1=5, sum(b1:b5),if(c1=7,sum(b1:b7),0)

 

[barry houdini]

Try

=SUM(B1:INDEX(B:B,C1))

 

[lenze]

Assuming data starts in B2

=SUM(INDIRECT("B2:B"&C2+1))

lenze

 

[skittles96]

This worked perfectly... thanks !!

=SUM(B1:INDEX(B:B,C1))