+ Reply to Thread
Results 1 to 5 of 5

Prices average

  1. #1
    Forum Contributor
    Join Date
    06-06-2007
    Posts
    248

    Prices average

    Dear sir,with best regards,i need your help to get the average of materials as mentioned in attached file.
    Many thanks in advance.
    Attached Files Attached Files
    Last edited by tofimoon4; 11-14-2011 at 02:51 AM.

  2. #2
    Forum Contributor
    Join Date
    06-06-2007
    Posts
    248

    Re: Prices average

    Dear sirs,with my apology,any hope to get any solution.

  3. #3
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Prices average

    Please allow 24 hrs before bumping ( see forum rules)

  4. #4
    Forum Expert Colin Legg's Avatar
    Join Date
    03-30-2008
    Location
    UK
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    1,252

    Re: Prices average

    Put this formula in K5 and then fill down.
    Please Login or Register  to view this content.
    It is an array formula, so when you type it into the formula bar, you must complete the entry with CTRL+SHIFT+ENTER, not just ENTER. If done correctly then Excel will automatically surround the formula with parentheses { }.
    Hope that helps,

    Colin

    RAD Excel Blog

  5. #5
    Forum Contributor
    Join Date
    06-06-2007
    Posts
    248

    Re: Prices average

    Dir sir,many thanks for this excellent formula,it works very nice .

+ Reply to Thread

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