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
[Uploaded an Excel file]
Excelchat Expert
10/10/2018 - 12:36
Could you please provide more details about the problem?
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
[Uploaded an Excel file]
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.