Hello

I am trying to find a formula to make excel show how many days holiday have been taken

The spreadsheet shows three months on one row, It uses L for full days off, and H for half days off. I want excel to add these up in a cell,

i tried =SUMIF(E4:CQ4,L,+1)(E4:CQ4,H,+0.5)

this doesn't seem to work,

could anyone help?

Thanks

Andrew