# Excel - AVERAGE Function Problem - Expert Solution

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

Trying to get certain columns to average, instead of including everything.
Solved by D. E. in 15 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 10/10/2018 - 12:36
Hi
User 10/10/2018 - 12:36
Hello
Excelchat Expert 10/10/2018 - 12:36
Welcome to excelchat
Excelchat Expert 10/10/2018 - 12:36
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows
Excelchat Expert 10/10/2018 - 12:36
Let me ask you a couple of quick questions to make sure I fully understand your problem.
User 10/10/2018 - 12:36
Excelchat Expert 10/10/2018 - 12:36
User 10/10/2018 - 12:37
ok, if you go to the ZD-MD tab I only want it to match the formulas with D6,D10 and D11
User 10/10/2018 - 12:37
in he 2018 Monthly average row
User 10/10/2018 - 12:37
I'm sorry the MD-Analysis tab
User 10/10/2018 - 12:39
does that make sense?
Excelchat Expert 10/10/2018 - 12:39
I am on those cells
Excelchat Expert 10/10/2018 - 12:39
I did not follow what you meant by match the formulas
User 10/10/2018 - 12:39
so I want the formulas in row 18 to mach only rows 6, 10 and 11
User 10/10/2018 - 12:39
ok look in D18
User 10/10/2018 - 12:39
do you see that formula?
Excelchat Expert 10/10/2018 - 12:40
one minute
Excelchat Expert 10/10/2018 - 12:40
I see that
User 10/10/2018 - 12:40
I don't want it to include row 7, 8, 9
User 10/10/2018 - 12:40
for the whole row of 18
Excelchat Expert 10/10/2018 - 12:41
okay
User 10/10/2018 - 12:41
same thing with he WA-Analysis tab
Excelchat Expert 10/10/2018 - 12:41
Is it like averaging only those which are greater than 0?
User 10/10/2018 - 12:41
yes
User 10/10/2018 - 12:42
Also, send when you are done please
Excelchat Expert 10/10/2018 - 12:43
I performed this in cell D18
Excelchat Expert 10/10/2018 - 12:43
In what other cells, do you want?
User 10/10/2018 - 12:43
ok can you do it all the way across
Excelchat Expert 10/10/2018 - 12:43
one minute
User 10/10/2018 - 12:43
I think it might just change automatially
User 10/10/2018 - 12:43
I don't think F18 needs it
User 10/10/2018 - 12:43
do not
Excelchat Expert 10/10/2018 - 12:44
So, the formula in F18 should not change?
User 10/10/2018 - 12:45
I don't believe so
User 10/10/2018 - 12:45
it's not averaging
User 10/10/2018 - 12:45
or is it?
Excelchat Expert 10/10/2018 - 12:45
Not averaging
User 10/10/2018 - 12:45
ok, just leave it
User 10/10/2018 - 12:45
just the ones that are averaging
Excelchat Expert 10/10/2018 - 12:45
sure
User 10/10/2018 - 12:45
then the WA Analysis tab and that's it
User 10/10/2018 - 12:46
same thin
User 10/10/2018 - 12:46
you can send it when done
Excelchat Expert 10/10/2018 - 12:49
Here it is
User 10/10/2018 - 12:49
cool, i'll look
Excelchat Expert 10/10/2018 - 12:49
sure
Excelchat Expert 10/10/2018 - 12:49
Let me know, if any modifications are required
User 10/10/2018 - 12:49
ok
User 10/10/2018 - 12:51
beautiful
User 10/10/2018 - 12:51
thanks
User 10/10/2018 - 12:51
that's all
User 10/10/2018 - 12:51
5 star

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.