Countif function to count as a half

[Minty5490]

I have a Key Section see belowH = 1 Full day holidayHD = 0.5 half day holidayI am trying to pull this into a summary sheet to add up. Each staff names are in rows with each have a cell under Jan to a total Holidays, but it adds H as 1, and HD as 1. When I want it to record HD as 0.5 half day off. These have to be in Letters, as the letters are keyed into a calendar showing H and HD etc, when some books a holiday.My formula is=SUM(COUNTIFS(Jan!D7:AH7,{"H","HD"}))
Jan Sheet Range of the dates 1st to the 31 month, H is holiday, HD half day holiday
where do I input a formula to ask it to make the HD a 0.5 half day holiday? thanks ​

 

[Snakehips]

Minty5490,

Two possibilities are....

=COUNTIFS(Jan!D7:AH7,"H")+COUNTIFS(Jan!D7:AH7,"HD")/2

=SUMPRODUCT((D7:AH7="H")+(D7:AH7="HD")/2)

Hope that helps.

 

[Marcelo Branco]

Or

=SUM(COUNTIFS(Jan!D7:AH7,{"H","HD"})*{1,0.5})

M.

 

[Minty5490]

Many Thanks,

They both work