Results 1 to 3 of 3

Thread: Cell Reference

  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Easley, South Carolina, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell Reference

    I am examining an Excel '97 Spreadsheet that has the following: AVERAGE(B6:C159). It appears to give same results as AVERAGE (B6:b15,c6:c15,d6:d15). What exactly is AVERAGE (B6:C159) doing? Any help appreciated. Have checked Excel Help, but does not really help. Thanks.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell Reference

    Thomas,

    I'd suspect that it's just trying to interpret an invalid range in the best way it can. In fact AVERAGE(B619) also gives the same result- and is more understandable. (Perhaps it was deliberately confusing because the person writing it wanted to keep it obscure so he was the only one who could decipher it?)
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    calacuccia
    Guest

    Re: Cell Reference

    I believe Excel tries to determine from such references the lowest and highest row and column number (in your example, the columns are B and D, the rows are 6 and 15, and then evaluates the complete range within these limits/
    So the formula AVERAGE(B6:C159) corresponds to AVERAGE(B616)

    If you enter a formula

    AVERAGE(D19:C2:A65) this will correspond to
    AVERAGE(A265)
    Of course, entering formula's this way is nonsense.

Posting Permissions

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