# =sumifs formula issue

#### fmxwannabe

##### New Member
Hi All,
Hoping somebody could please help me. I'm using a SUMIFS formula however it keeps returning \$0.00 as the result which is incorrect.

Formula is;
Code:
``=SUMIFS(B:B,A:A,"=325299",A:A,"=325300",A:A,"=325303")``

Can somebody tell me what I'm doing wrong and provide an anwser to get this to work?

Thanks
Zane

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### Tony Miall

##### Active Member
what exactly are you trying to do?

#### Weazel

##### Well-known Member
maybe something like...

=SUM(SUMIF(A:A,{325299,325300},B:B))

#### teylyn

##### Active Member
Hello,
are you trying to do a series of conditions with OR as the logic? If so, see here

http://www.mrexcel.com/forum/excel-questions/630118-sumifs-condition.html

This would make your formula something like
Code:
``=SUM(SUMIF(A1:A20,{"=[COLOR=#333333]325299[/COLOR]","=[COLOR=#333333]325300[/COLOR]","=[COLOR=#333333]325303[/COLOR]"},B1:B20))``

If the values in column A are numbers, you can use
Code:
``=SUM(SUMIF(A1:A20,{[COLOR=#333333]325299[/COLOR],[COLOR=#333333]325300[/COLOR],[COLOR=#333333]325303[/COLOR]},B1:B20))``

cheers, teylyn

#### vogel997

##### Active Member
I can't figure out why Sumifs doesn't work, but try this one

=SUMPRODUCT(--(A:A=325299)+--(A:A=325300)+--(A:A=325303),B:B)

#### Weazel

##### Well-known Member
Just an alternative if you wanted to put the criteria in individual cells....

=SUMPRODUCT(SUMIF(A3:A10,F1:F2,B3:B10))

where F1:F2 would contain 325299 and 325300

Replies
3
Views
80
Replies
17
Views
679
Replies
2
Views
233
Replies
7
Views
360
Replies
3
Views
1K

1,171,579
Messages
5,876,292
Members
433,193
Latest member

### 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