Results 1 to 3 of 3

Need help calculating an average using a named range

Threaded View

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    Gold coast,Australia
    MS-Off Ver
    Excel 2010
    Posts
    5

    Question Need help calculating an average using a named range

    Good evening everyone

    I have a table of prices for which I need to calculate the AVERAGE price for. This table contains 4 different columns (including a date column, others are prices. This table is a named range of cells, named prices. I am able to work out average price using the cell ranges but not using the named range.

    I am entering the average answer into another table (column 3)

    My formula starts =AVERAGE(

    Any help would be greatly appreciated, thanks
    Last edited by stacey69; 04-19-2013 at 09:56 AM. Reason: attach file

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1