Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with a formula
I have a worksheet that has tabs for each month. I want to track the avg use
of a material we use for the last five workingdays... So no problem untill I need to go look at the previous month tab for that last few days of the month, to avg with the first few days of the current month. And I want it to skip the cell if it is empty So if I want to do a running five day avg, and skip the cell if it is empty, and look at another sheet, what would that formual look like. |