Please find below formula: add this is in the cell: AG5
=COUNTA(tblJanuary[[#This Row],[1]:[31]])-COUNTIF(tblJanuary[[#This Row],[1]:[31]],"H")/2