Please assume that my data will look like this:
Month Amount
January 10,000
February 14,000
March 6,000
April 8,000
May 30,000
June 0
July -10,000
August 100,000
September 25
October 9,200
November 7,000
December 5,500

Month

Total

In the cell next to "Month" a user will enter a value between 1 and 12.
Let's say that the user enters the number 4. In the cell next to "Total" I
want a formula that will add the months of January through April and return
a value of 38,000. I can not get a SUMIF Formula to do this. If tyhe user
were to enter a value of 9 then the Total should be 158,025. I have tried to
use the SUMIF funtion with the criteria portion of that formula referencing
the content of the cell next to Month but it doesn't work.

Any ideas on wgat I am doing wrong?

Assume your data in A1:B13 with header in row 1
criteria in D2

In D4: =SUM(B2:INDEX(B2:B13,D2))


"Mike" wrote:

Please assume that my data will look like this:
Month Amount
January 10,000
February 14,000
March 6,000
April 8,000
May 30,000
June 0
July -10,000
August 100,000
September 25
October 9,200
November 7,000
December 5,500

Month

Total

In the cell next to "Month" a user will enter a value between 1 and 12.
Let's say that the user enters the number 4. In the cell next to "Total" I
want a formula that will add the months of January through April and return
a value of 38,000. I can not get a SUMIF Formula to do this. If tyhe user
were to enter a value of 9 then the Total should be 158,025. I have tried to
use the SUMIF funtion with the criteria portion of that formula referencing
the content of the cell next to Month but it doesn't work.

Any ideas on wgat I am doing wrong?