Sum calculation based on results of another field
I have a calculation field that looks like this:
Sum (Field1; Field2; Field3; Field4; Field5; Field6)
I have 6 more fields that follow these ones that are a yes/no result. So, for instance, Field1 is a number and FieldA is a yes/no result, Field2 is a number and FieldB is a yes/no result, etc., etc.
I would like the Sum calculation to only include the field if the related field has a yes result.
Can anyone help me out?
Many many thanks in advance!!