Dear sir,with best regards,i need your help to get the average of materials as mentioned in attached file.
Many thanks in advance.
Dear sir,with best regards,i need your help to get the average of materials as mentioned in attached file.
Many thanks in advance.
Last edited by tofimoon4; 11-14-2011 at 02:51 AM.
Dear sirs,with my apology,any hope to get any solution.
Please allow 24 hrs before bumping ( see forum rules)
Put this formula in K5 and then fill down.
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 { }.![]()
Please Login or Register to view this content.
Dir sir,many thanks for this excellent formula,it works very nice .
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks