General Excel Formulas

[Red_Rider]

Good Morning, all. I'm a beginner with Excel and would like some help in figuring out the proper formula for the screenshot below. What I'm trying to do is be able to put in total Gross Profit for each day of the month and then have Excel tell me what I'm pacing to hit in Gross Profit at the end of the month. Again, I'm a beginner to Excel as I have never needed to use it for formulas except for adding up numbers. Any help will greatly be appreciated! Thank you in advance!

 

[Red_Rider]

Help With Formulas - Calculating Pace for End Of Month

I'm looking for help with figuring out the proper formula in Excel to calculate what amount in Gross Profit I am pacing to achieve at the end of the month. I know how to manually figure it out with simple math, however, I would like Excel to do it for me automatically. Below is a screenshot of what I already have. Thank you in advance!

 

[oldbrewer]

Re: Help With Formulas - Calculating Pace for End Of Month

assuming pace on day 3 is approx 1699 per day formula for that is =sum($b$2:b4)/counta($b$2:$b$31) not tested

 

[igold]

Re: Help With Formulas - Calculating Pace for End Of Month

How about this in cell B33:

=AVERAGE(B2:B31)*DAY(DATE(YEAR(A2),MONTH(A2)+1,1)-1)

 

[Murphy123]

Re: Help With Formulas - Calculating Pace for End Of Month

Hi
Try this

=B32/COUNTA(B2:B31)*DAY(EOMONTH(A2,0))
assuming column A is formatted as dates

Regards
Murphy123

 

[rpaulson]

take the average and mulpilty it by how many days in the month

=AVERAGE(B2:B31)*30

 

[Joe4]

I have merged your two threads together.

In the future, please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).