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..
Bookmarks