How do you do....it? Thread, Excel 2007 in Technical; Okay I probably won't explain this very well but here goes. I have an excel sheet there is data populated ...
1. ## Excel 2007

Okay I probably won't explain this very well but here goes.

I have an excel sheet there is data populated from B2:B10 - AE2:AE10

I want to give a running average for each so say b49:b57 would hold all of the b2:b10 values divided by 1 b49:c57 would hold b2+c2 to b10+c10 divied by 2 and so forth is there an easier way than inputting these manually so say ten cells in it would know to add b2+c2+d2+e2+f2+g2+h2+i2+j2+k2 et cetera and divid by the amount of columns between them? I would need to make sure any value of zero wasn't counted though?

Wes

2. ## Re: Excel 2007

have you got a picture

3. ## Re: Excel 2007

Complete gibberish!

As luck might have it, I'm completely conversant in gibberish.

Why would you want to do such a warped thing?

I think what your asking is to have an automated method of averaging the sum of n columns, without having to enter this in a formula?

Is that right?

Wes

My eyes!

7. ## Re: Excel 2007

lol. Scary isn't it?

Wes

8. ## Re: Excel 2007

Originally Posted by wesleyw
.... so say ten cells in it would know to add b2+c2+d2+e2+f2+g2+h2+i2+j2+k2 et cetera and divid by the amount of columns between them? I would need to make sure any value of zero wasn't counted though?
For this example =SUM(B2:K2)/COUNTIF(B2:K2,">0")

Final cell AE49 would be =SUM(B2:AE2)/COUNTIF(B2:AE2,">0")

Should be resonably easy to replicate using reference cells and find + replace.

SHARE: