formula to work out cost including multiple discounts

Hello,

New to forum here...

I'm hoping someone with better skills that me can help with a complicated formula for working out prices including applying discounts.

Please see here

I'm looking for the correct formula for G6,G8,G10 and G15,G17 and G19

I think I have them correct(?) to include standard days and extended days but I can't make it work to include Half days.
The formula gets too complicated for me to follow.

Please help if you can :)

Hi, for one way try this in cell G6 and copy down.

=IF(COUNTIF(B6:F7,"H*")=5,$D$1,IF(COUNTIF(B6:F7,"S*")=5,$D$2,IF(COUNTIF(B6:F7,"E*")=5,$D$3,(COUNTIF(B6:F7,"H*")*$B$1)+(COUNTIF(B6:F7,"S*")*$B$2)+(COUNTIF(B6:F7,"E*")*$B$3))))

I'm sure there are tidier methods though.