This can be done, but it appears you have a very cumbersome design for your table. It would appear a better structure to have a table of related records with one yes/no field and one number field in each related record.
To solve the immediate problem,
add a series of calculation fields written with this pattern:
If ( FieldA = "yes" ; field1 )
This calculation will return the number in field1 if FieldA stores the text "yes" and will be empty if it does not.
Then sum these calculation fields instead of the original number fields.
That will work. Thank you!!