# Budgeting and Sales data

#### shanka2020

##### New Member
Hi there Excel Wizzes, I hope you can help. I'm trying to keep track of my sales team budget versus sales on a weekly basis by dividing their monthly budget into 4 weeks and then tracking their weekly sales against this. I would like to provide them at the start of the month their weekly targets (eg. Budget \$1000 so Wk 1 \$250, Wk 2 \$250 etc) and then as they pull in sales I can add them to a total and the remaining weeks are then recalculated to reflect the balance remaining. I have created a spreadsheet already with some of this info on it if that makes it easier for you guys to work off, just ask and I will post it.

Thanks in Advance to you all

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

#### jorismoerings

##### Well-known Member
Hi,

You didn't asked a specific question so there's little to go on. But try this.

ABCDE
1target1200
2
3
4WeeknoTargetSalesRemain WkRemain Target
513002001001000
623003000700
73300300700
84300300700

</tbody>
Sheet1

Worksheet Formulas
CellFormula
D5=[@Target]-[@Sales]
E5=\$B\$1-SUM(\$C\$4:C5)
D6=[@Target]-[@Sales]
E6=\$B\$1-SUM(\$C\$4:C6)
D7=[@Target]-[@Sales]
E7=\$B\$1-SUM(\$C\$4:C7)
D8=[@Target]-[@Sales]
E8=\$B\$1-SUM(\$C\$4:C8)
B5=\$B\$1/4
B6=\$B\$1/4
B7=\$B\$1/4
B8=\$B\$1/4

</tbody>

<tbody>
</tbody>

Replies
1
Views
278
Replies
1
Views
110
Replies
0
Views
120
Replies
2
Views
314
Replies
0
Views
75