philosopher76
asked on
How to automatically update a formula after typing the last value.
I have a formula that substract total expenses from total sales. However I would like to get the net profit average after day number 2, 3 and so on...located in  column "P" or if it is not possible in column "Q".
The info is in the Menu Details worksheet.
Any help will be very much appreciated
August-2015.xlsm
The info is in the Menu Details worksheet.
Any help will be very much appreciated
August-2015.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The solution is perfect. I sent the Spanish version file but Hammadh did a great job!
Experts, FYI - the sheet is named 'DETALLE DE MENUS' and is currently hidden on the supplied workbook.