Excel Formula Query on Summing Annual Leave Days and Half Days

Question

I'm making leave trackers for several of my staff. This tracker keeps tabs on sick days, partial days, parental leaves, annual leaves, and work-from-home days.

Each of the 12 tabs represents a month of the calendar and highlights the days and dates. At the bottom of each tab is a total column that counts the number of annual leaves and half-days only (as the others are not deducted from their annual allowance).

Annual Leaves = A

Half Days = HA

Is there a formula I can use, to sum up the annual leaves and half days for each employee where half days is equal to 0.5 of a day rather than a day? So if one has 2 days of annual leave in January and 3 half-day leaves in January; what formula can I use to show 3.5?

Answer 1

Try Something like =SUM(COUNTIF($A$1:$A$8,"A"),COUNTIF($A$1:$A$8,"HA")/2) - total count of A, and total count of HA divided by 2.