Need Assistance for a Formula

Hello All,   I need a formula for Calculating the attendance Data with the Below conditions, I am attaching the sheet for reference Template  When Ever I enter Present it should be added in the T...