# Excel 2007

• 25th June 2007, 01:40 PM
wesleyw
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
• 25th June 2007, 01:44 PM
rush_tech
Re: Excel 2007
have you got a picture :wink:
• 25th June 2007, 02:00 PM
Wildebeaste
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?
• 25th June 2007, 02:02 PM
Wildebeaste
Re: Excel 2007
• 25th June 2007, 02:04 PM
wesleyw
Re: Excel 2007

Wes
• 25th June 2007, 02:17 PM
Geoff
Re: Excel 2007
My eyes!
• 25th June 2007, 02:19 PM
wesleyw
Re: Excel 2007
lol. Scary isn't it?

Wes
• 25th June 2007, 06:39 PM
steve
Re: Excel 2007
Quote:

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.