Excel 2007

[wesleyw]

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

[rush_tech]

have you got a picture

[Wildebeaste]

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?

[Wildebeaste]

Ignore me. Your request is giving me a headache.

[wesleyw]

Yep thats about right



Wes

[Geoff]

My eyes!

[wesleyw]

lol. Scary isn't it?


Wes

[steve]

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