#### bcollins124

##### New Member

- Joined
- May 19, 2015

- Messages
- 5

Task: I need to create projected sales forecast for each of the remaining months of the 2015

I am trying to create a formula that sums the current months totals and all those that precede it in Column B. The once catch is that cell B5 through B12 must refer to the prospective sales figures in prior year (Column C) because there is nothing to total yet for in 2015.

So basically I would to create a formula that sums B1 through B4 and C5 through C12. My only question is, in two weeks I am going to have to enter the sales results for May in cell B5 but I don't want to the formula to sum the sales in cell C5 - how can I make it so I don't have to adjust the formula range each month?

--A------B-----C

Month 2015 2014

1 Jan. 850 925

2 Feb. 950 925

3 Mar. 975 950

4 Apr. 925 975

5 May --- 900

6 Jun. --- 800

7 Jul. --- 700

8 Aug. --- 750

9 Sep. --- 800

10 Oct. --- 700

11 Nov. --- 800

12 Dec. --- 800

TOTAL $3,700 $10,025

I am trying to create a formula that sums the current months totals and all those that precede it in Column B. The once catch is that cell B5 through B12 must refer to the prospective sales figures in prior year (Column C) because there is nothing to total yet for in 2015.

So basically I would to create a formula that sums B1 through B4 and C5 through C12. My only question is, in two weeks I am going to have to enter the sales results for May in cell B5 but I don't want to the formula to sum the sales in cell C5 - how can I make it so I don't have to adjust the formula range each month?

--A------B-----C

Month 2015 2014

1 Jan. 850 925

2 Feb. 950 925

3 Mar. 975 950

4 Apr. 925 975

5 May --- 900

6 Jun. --- 800

7 Jul. --- 700

8 Aug. --- 750

9 Sep. --- 800

10 Oct. --- 700

11 Nov. --- 800

12 Dec. --- 800

TOTAL $3,700 $10,025

Last edited: