Staff Absence Record

Hi,

I'm so confused . You don't want the total number of days absent for a month or year? On your individual name sheets you are allowed two different letters per day. How is that supposed to show up on the Front Page, when there is only a single cell to display letters?

Because of merged cells on the named sheets and no merged cells on the Front Page, I failed to get a formula that worked. I did get close.
Maybe one of the smart Guru's can get you a formula for this problem. OR - maybe you can study the formula I have already on the Front Page and make it work.