Adapting an IF formula..

Hello, the following formula works just fine

=SUM(Sheet1!B5:F5,IF(Sheet1!B6="S",-6,0),IF(Sheet1!C6="S",-7.5,0),IF(Sheet1!D6="S",-7.5,0),IF(Sheet1!E6="S",-7.5,0),IF(Sheet1!F6="S",-7.5,0),IF(Sheet1!B6="UH",-6))

But can anyone tell me how I can adapt it so that it is either "S" or "H" that will produce the same result..

Many thanks in advance..

...IF(OR(Sheet1!B6="H",Sheet1!B6="S"),-6,0),...


Regards

You can use OR like this

=SUM(Sheet1!B5:F5,IF(OR(Sheet1!B6={"S";"H"}),-6,0),IF(OR(Sheet1!C6={"S";"H"}),-7.5,0),IF(OR(Sheet1!D6={"S";"H"}),-7.5,0),IF(OR(Sheet1!E6={"S";"H"}),-7.5,0),IF(OR(Sheet1!F6={"S";"H"}),-7.5,0),IF(Sheet1!B6="UH",-6))