S
SD
Hello-
I store all my sales data in a microsoft excel sheet. I was wondering
how I can automatically have the daily average sales displayed at the
bottom of the sheet without having to manually compute it each day.
For example, if today is the 7th of May and I look at my sheet after
entering in the sales for yesterday and there are 31 days in this
month, what function do I use to compute the average at the bottom so
the computer automatically knows each day that I want to take the days
of the month thus far (as of yesterday, that would be 6) and divide it
by the revenue already summed up month to date (thats easy)..
Currently, I manually have to break out the calculator...divide the
MTD sales by 6 and multiply it by 31 to forcast my monthly average
sales..
What I would like to do is have a cell automatically do this for me
without me having to tell excel that there is 6 days in the month,
etc. I hope this is clear
Any Suggestions Would Be helpful.
Thanks
SD.
I store all my sales data in a microsoft excel sheet. I was wondering
how I can automatically have the daily average sales displayed at the
bottom of the sheet without having to manually compute it each day.
For example, if today is the 7th of May and I look at my sheet after
entering in the sales for yesterday and there are 31 days in this
month, what function do I use to compute the average at the bottom so
the computer automatically knows each day that I want to take the days
of the month thus far (as of yesterday, that would be 6) and divide it
by the revenue already summed up month to date (thats easy)..
Currently, I manually have to break out the calculator...divide the
MTD sales by 6 and multiply it by 31 to forcast my monthly average
sales..
What I would like to do is have a cell automatically do this for me
without me having to tell excel that there is 6 days in the month,
etc. I hope this is clear
Any Suggestions Would Be helpful.
Thanks
SD.