D
Donna
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.
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.