**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.*