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

=countif((d21:ct26,"h")+countif((d21:ct26,"hh")*0. 5

I'm afraid I still get an error message trying this formula. Thanks

Which error message please?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Somehow, it appears a few extraneous parentheses were added above. Try this...

=countif(d21:ct26,"h")+countif(d21:ct26,"hh")*0.5

Yay that worked! Thank you so much!!

Dear Stupidgirl,

Attached is the simulated sample of count full and half Holiday. I hope it solves your problem.

Attached Files

StupidGirl.xlsx (12.2 KB, 11 views)