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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks