How do I conditionally sum a cell based on the value of another cell?-CodePudding

Home > database > How do I conditionally sum a cell based on the value of another cell?

How do I conditionally sum a cell based on the value of another cell?

Time：03-11

I have a terrible formula that looks like this:

=if(B17="Yes",B$7) if(C17="Yes",C$7) if(D17="Yes",D$7) if(E17="Yes",E$7) if(F17="Yes",F$7)

I'd also like to be able to expand it if I go longer than column F.

Basically, other people can change their own row, in this example row 17, but there are many many rows just like it.