+ Post New Thread
Results 1 to 8 of 8
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. #1
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,208
    Thank Post
    225
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

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

    rush_tech's Avatar
    Join Date
    Jul 2006
    Location
    Nottingham
    Posts
    1,410
    Thank Post
    111
    Thanked 265 Times in 201 Posts
    Rep Power
    194

    Re: Excel 2007

    have you got a picture

  3. #3
    Wildebeaste's Avatar
    Join Date
    Oct 2006
    Location
    Nottinghamshire
    Posts
    64
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    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?

  4. #4
    Wildebeaste's Avatar
    Join Date
    Oct 2006
    Location
    Nottinghamshire
    Posts
    64
    Thank Post
    12
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Excel 2007

    Ignore me. Your request is giving me a headache.

  5. #5
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,208
    Thank Post
    225
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Re: Excel 2007

    Yep thats about right



    Wes
    Attached Images Attached Images

  6. #6

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,804
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Excel 2007

    My eyes!

  7. #7
    wesleyw's Avatar
    Join Date
    Dec 2005
    Location
    Kingswinford
    Posts
    2,208
    Thank Post
    225
    Thanked 50 Times in 44 Posts
    Blog Entries
    1
    Rep Power
    30

    Re: Excel 2007

    lol. Scary isn't it?


    Wes

  8. #8
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,043
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52

    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Excel sum problem
    By wesleyw in forum How do you do....it?
    Replies: 8
    Last Post: 29th August 2009, 11:23 AM
  2. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM
  3. Excel 2007 Chart Types
    By wesleyw in forum How do you do....it?
    Replies: 0
    Last Post: 12th September 2007, 11:01 AM
  4. Excel 2007
    By wesleyw in forum Windows
    Replies: 0
    Last Post: 22nd June 2007, 03:31 PM
  5. Help!!!!!!! With Excel 2003
    By jodielynn in forum Windows
    Replies: 3
    Last Post: 16th May 2007, 04:19 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •