Totals output for last post ( HTML )

Excel 2007 32 bit
BCDEFGHIJ
34TOTAL NO. OF DAYS  ----->25Normal Overtime  ----->39Holiday Overtime  ----->18

After121



Worksheet Formulas
CellFormula
C34=30-COUNTIF(K1:K31,"ABSENT")
G34=SUMIF(L1:L31,"N",J1:J31)*24
J34=SUMIF(L1:L31,"H",J1:J31)*24