I need to calculate a monthy pace

Question

_{Thursday, February 21, 2013 5:44 PM}

I need to calculate a pace for example if a year to day sales goal is 12 k than each month should be 1k, and Jan was 750 and Feb was 200 than the pace will be -50, i need it to update with everymonth.

All replies (1)

_{Thursday, February 21, 2013 8:10 PM ✅Answered}

On the very brief details that you provide see if this works for you:-

A1 - Actual

B1 - Budget

C1 - Over / Under

Cells A2 to A13 is where you put in your actuals.

Cells B2 to B13 is where you put in your budget (1,000 in each cell). Enter these as the months pass (if required).

Cell A14 has:-

=SUM(A2:A13)

Cells B14 has:-

=SUM(B2:B13)

Cell C14 has:-

=(A14-B14)