Help: Need to calculate Month to date

[mimikat]

Hello, Im hoping someone can help me with this.
Not sure if my title is correct as to what i need… here is a description of what I'm trying to create:

I have sales data for Months of January through December all in different columns. At the end of these months i have a column where i need to calculate month to date.

For ex: If i have sales data for the months of Jan. through March and I enter April sales data it will automatically update the calculation in my last column which i have titled month to date.

Please help =-/

 

[mimikat]

is it possible to enter the goal only once since my goal is the same for every month?
I have tried adding a goal column as yours is for each month and entering the goal for each month in that column however the formula picks up that goal for all following months even though i have no sales data for those months.
Id like this spreadsheet to be where all i need to do is enter the sales data for each month and it will automatically subtract it from the goal and add to my "Month to Date" column in addition with all past months (goal minus sales) data.

 

[gaz_chops]

Try
=SUM(B2:M2)-(COUNT(B2:M2)*A2)

Note this is Sales minus Goal, which i think is correct, if for example in Jan we used Goal minus Sales it would show +25000 (when it prob should be -25000).
If you really want it that way! Simply change the formula around =(COUNT(B2:M2)*A2)-SUM(B2:M2)

[TABLE="width: 519"]
<tbody>[TR]
[TD]Goal[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[TD]MonthToDate[/TD]
[/TR]
[TR]
[TD="align: right"]100,000[/TD]
[TD="align: right"]75,000[/TD]
[TD="align: right"]100,000[/TD]
[TD="align: right"]125,000[/TD]
[TD="align: right"]145,000[/TD]
[TD="align: right"]85,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]30,000[/TD]
[/TR]
</tbody>[/TABLE]

Gaz

 

[mimikat]

Try
=SUM(B2:M2)-(COUNT(B2:M2)*A2)

Note this is Sales minus Goal, which i think is correct, if for example in Jan we used Goal minus Sales it would show +25000 (when it prob should be -25000).
If you really want it that way! Simply change the formula around =(COUNT(B2:M2)*A2)-SUM(B2:M2)

[TABLE="width: 519"]
<tbody>[TR]
[TD]Goal[/TD]
[TD]Jan[/TD]
[TD]Feb[/TD]
[TD]Mar[/TD]
[TD]Apr[/TD]
[TD]May[/TD]
[TD]Jun[/TD]
[TD]Jul[/TD]
[TD]Aug[/TD]
[TD]Sep[/TD]
[TD]Oct[/TD]
[TD]Nov[/TD]
[TD]Dec[/TD]
[TD]MonthToDate[/TD]
[/TR]
[TR]
[TD="align: right"]100,000[/TD]
[TD="align: right"]75,000[/TD]
[TD="align: right"]100,000[/TD]
[TD="align: right"]125,000[/TD]
[TD="align: right"]145,000[/TD]
[TD="align: right"]85,000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]30,000[/TD]
[/TR]
</tbody>[/TABLE]

Gaz

THIS WORKED PERFECT! Thank you so much!

 

[gaz_chops]

You're welcome.