Hi,


I have a spreadsheet with various cells that either have H or HH (and also S or SS). The double letter represents half a day sick (S) or half a day holiday (H) and the single letter represents the full day.

I have a formula in my totals cell which currently counts all H's
=COUNTIF(D21:CT26,"H")
This is working fine. What I now need to add to the formula is that within the same criteria (D21:CT26) it finds all HH data in the same set of cells, multiplies them by 0.5 to make it a half day, and adds these to the same cell where the above formula is already in (my total holiday days)
I need to only multiple the HH before they get added up and combined with the H totals.

Thanks