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 formula below shows the forecast in its simplest form. *The once catch is that the cells B5 through B12 must refer to the prospective values in prior year (Column C) because there is nothing to total yet.
formula: (sum=B1+B2+B3+B4+C5+C6+C7+C8+C9+C10+C11+C12)
--A------B-----C
Month 2015 2014
1 Jan. 900 925
2 Feb. 950 925
3 Mar. 975 950
4 Apr. 950 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,775 $10,025
Bookmarks