How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Richard Your Own Question
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 36865
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I need to find the correct way to get average sales per month

Customer Question

I need to find the correct way to get average sales per month from another worksheet in the workbook. The monthly totals sales of 4 different districts are $8,150 ,$3,085, $3,030 and $5,260. How do I create the formula on #2 worksheet from info on #1 worksheet getting the average sales should show the average sales per month for each of those districts. Am I making since lol Can you help
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  Richard replied 2 years ago.
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, click on Reply to Expert to reply to me, a rating is only needed when we are finished.
To do this, lets say the values are in A1 to A4 in Sheet 1
Then in sheet 2 you put this formula
Which will give you the average from the values in the other sheet.
If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.
And if you can take a second to rate my service by clicking one of the stars at the top of the screen and then submit, that would be greatly appreciated.
Thank you

Related Microsoft Office Questions