Sum "or" Function

[Berandon]

I have a drop down window of tasks. I want it to add up another column if it says Sewing or Assembling. I can only get it to do do one. I tried =SumIFS and I think it wants both the be true cause it returns zero. If i delete one of the criteria then it does it right. I also tried an "or" function within the sumif and i just got "0"

Is there a formula I am not thinking of that would work?

 

[VoG]

Please post your formula.

 

[C Moore]

=sumproduct(((rangetocheck="Sewing")+(rangetocheck="Assembling"))*(rangetoadd)) , its array formula so Ctrl+Shift+Enter

 

[barry houdini]

Try this version

=SUM(SUMIF(A:A,{"sewing","assembling"},B:B))

 

[Berandon]

ADVERTISEMENT

I have a few I've been trying.

=SUMIF(J9:J2000,OR(J9:J2000="Assemble",J9:J2000="Weld",J9:J2000="paint"),O9:O2000)

=SUMIFS((J9:J2000,"Assemble","Weld","paint"),O9:O2000)

I want to to sum if one of those is true.

 

[Aladin Akyurek]

I have a few I've been trying.

=SUMIF(J9:J2000,OR(J9:J2000="Assemble",J9:J2000="Weld",J9:J2000="paint"),O9:O2000)

=SUMIFS((J9:J2000,"Assemble","Weld","paint"),O9:O2000)

I want to to sum if one of those is true.

=SUM(SUMIF(J9:J2000,{"Assemble","Weld","paint"},O9:O2000))

would sum the O-range if any text value would hold for the J-range.

 

[Berandon]

ADVERTISEMENT

Try this version

=SUM(SUMIF(A:A,{"sewing","assembling"},B:B))

=SUM(SUMIF(J9:J2000,{"sewing","assembling"},O9:O2000))

Still comes back "0"

I think it wants both to be true in this formula

 

[Berandon]

=SUM(SUMIF(J9:J2000,{"Assemble","Weld","paint"},O9:O2000))

would sum the O-range if any text value would hold for the J-range.

That one worked.. thank you

is it the {} ? what do those do?

 

[Aladin Akyurek]

That one worked.. thank you

is it the {} ? what do those do?

Allows SumIf to run for each value the pair { and } envelops.

Select the formula on the formula bar and hit F9 to see what that means.

 

[Berandon]

Thank you so much for your help.