# Sum "or" Function

#### Berandon

##### New Member
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?

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

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

Try this version

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

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.

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.

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

=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?

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.

Thank you so much for your help.

Replies
3
Views
242
Replies
3
Views
1K
Replies
7
Views
268
Replies
3
Views
95
Replies
8
Views
183

1,196,438
Messages
6,015,277
Members
441,885
Latest member
Gop

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back