# Excel - AVERAGE Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

What is the formula to add 4 cell and add them together in another cell then in another call get the average of that cell
Solved by C. J. in 37 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 04/06/2018 - 01:04
HI how are you?
User 04/06/2018 - 01:04
good thank you.
User 04/06/2018 - 01:04
and you ?
Excelchat Expert 04/06/2018 - 01:05
I'm good, thanks for asking :)
Excelchat Expert 04/06/2018 - 01:05
Is it possible to ask for a sample data to better understand your problem statement? You may type in the document preview to the right.
User 04/06/2018 - 01:06
the spreadsheet is for hours and payroll.
User 04/06/2018 - 01:06
ok will do
Excelchat Expert 04/06/2018 - 01:06
Alright, that's noted. Thanks :)
Excelchat Expert 04/06/2018 - 01:07
Do let me know once you're done, okay? I'll keep watching the screen update
Excelchat Expert 04/06/2018 - 01:10
I hope you don't mind while I do simultaneous edits with you - i'll color the formula cells in yellow, okay?
User 04/06/2018 - 01:11
ok no worries I'm looking on my spread sheet
Excelchat Expert 04/06/2018 - 01:12
Thanks. Are you done?
User 04/06/2018 - 01:12
getting there
Excelchat Expert 04/06/2018 - 01:12
Excelchat Expert 04/06/2018 - 01:19
By the way, please feel free to extend if you need more time. We are allowed for a maximum of 2 20-minutes free extensions per session.
User 04/06/2018 - 01:19
ok great thanks!
User 04/06/2018 - 01:19
I am complete
Excelchat Expert 04/06/2018 - 01:20
Are you able to see the cells in yellow?
Excelchat Expert 04/06/2018 - 01:20
I tried to label them as well so you could easily follow the formula and reference used
User 04/06/2018 - 01:20
yes
User 04/06/2018 - 01:21
ok thank you .
Excelchat Expert 04/06/2018 - 01:21
So first, on cell D20 - the formula is SUM(B19:B22)
User 04/06/2018 - 01:21
I am going to check with the sales guy super quick and then I will be back in a minute or so.
Excelchat Expert 04/06/2018 - 01:22
sure
User 04/06/2018 - 01:22
I dig on this service! might have to pay the frr
Excelchat Expert 04/06/2018 - 01:23
Let me know if you are ready.
User 04/06/2018 - 01:24
brb
User 04/06/2018 - 01:30
ok. So For the next peoples time sheets I should just copy the cell and paste the formula?
Excelchat Expert 04/06/2018 - 01:31
Basically that should normally be the case except for cases where your gross pay includes more that 4 rows/cells i.e. the second example.
Excelchat Expert 04/06/2018 - 01:33
You have to take note what is the first cell and the last cell in your SUM() formula
User 04/06/2018 - 01:33
ok great !
Excelchat Expert 04/06/2018 - 01:33
in this case that would be B27, the first cell in the range, and B38, the last.
Excelchat Expert 04/06/2018 - 01:34
So that would be SUM(B27:B38)
Excelchat Expert 04/06/2018 - 01:35
Excelchat Expert 04/06/2018 - 01:35
Or would you like me to elaborate further?
User 04/06/2018 - 01:35
Great. very much so. You were really helpful. Thanks you!
Excelchat Expert 04/06/2018 - 01:35
You're welcome
Excelchat Expert 04/06/2018 - 01:36
Excelchat Expert 04/06/2018 - 01:36
Excelchat Expert 04/06/2018 - 01:37
If you don't have any more clarifications at this point, you may end the session by hovering over the TIME REMAINING section of this chat window and select END SESSION
Excelchat Expert 04/06/2018 - 01:37
Also, I'd appreciate if you could drop a few lines for your kind and honest feedback on a survey after this session. Any constructive criticism or points for improvement are also welcome. Many thanks and have a good day!
User 04/06/2018 - 01:38
ok I will. do you send it to me?
Excelchat Expert 04/06/2018 - 01:38
I could send it to you
Excelchat Expert 04/06/2018 - 01:38
User 04/06/2018 - 01:38
Sure - thank again!
Excelchat Expert 04/06/2018 - 01:39
Kindly save a copy of this
User 04/06/2018 - 01:40
ok ok
Excelchat Expert 04/06/2018 - 01:40
*you may end the session by hovering over the TIME REMAINING section of this chat window and select CLOSE/END SESSION
Excelchat Expert 04/06/2018 - 01:41
Thanks again for choosing ExcelChat

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.