Sumif question

[Selo]

I got 2 formula's that I am trying to add together but cant get it to work

this are the formula's
=SOM(O11,Q9,S6,U8,W5,Y6,AA4)
=ALS(R24=1,"Yes",ALS(R24=0,"No"))

I tryed with sumproduct and sumif ut cant figure it out

Does anyone know how to solve this?

ALS = IF
SOM = SUM

[daddylonglegs]

It depends how you want to "add" the formulas. Do you mean you want the sum to replace "Yes" in the IF formula so that if R24 is 1 you get the result of the sum, otherwise you get zero? If so try

=ALS(R24=1,SOM(O11,Q9,S6,U8,W5,Y6,AA4),0)

[Selo]

It depends how you want to "add" the formulas. Do you mean you want the sum to replace "Yes" in the IF formula so that if R24 is 1 you get the result of the sum, otherwise you get zero? If so try

=ALS(R24=1,SOM(O11,Q9,S6,U8,W5,Y6,AA4),0)

R24 can only be 1 if the sum calculate that

the sum can only be 1 or 0
SOM(O11,Q9,S6,U8,W5,Y6,AA4)

so if the out come of the sum is 1 then Yes if it is 0 then No

[daddylonglegs]

Ok then try

=ALS(SOM(O11,Q9,S6,U8,W5,Y6,AA4)=1,"Yes","No")

[Selo]

That works great thank you