# Sumifs returning 0

#### sperling1349

##### New Member
I have three columns of data: Date, Item, Quantity. Dates are formatted like this: 1/3/2013. Item cells are all text, no trailing spaces - tried to make sure of that. Quantity column is all formatted as numbers.

Here is the formula that is giving me problems:

=SUMIFS(C2:C7344,A2:A7344,">=1/1/2013",A2:A7344,"<=1/31/2013",B2:B7344,”BMX1RG”)

That formula returns a 0 and it should be 19.

When I use this formula I get the correct number for all Items for the month of January:

=SUMIFS(C2:C7344,A2:A7344,">=1/1/2013",A2:A7344,"<=1/31/2013")

So I know at least part of the formula is working since it searches out everything in the month of January and returns the correct amount, but adding in that last search criteria forces a 0.

What am I doing wrong and how do I get the first formula to return the correct number for the item?

Thanks, and I hope I explained it well enough.

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### barry houdini

##### MrExcel MVP
Hello sperling1349, welcome to MrExcel

I don't know if it's just in the version posted here but the quotes around BMX1RG look different to your other quotes - try re-typing those or copy from here

=SUMIFS(C2:C7344,A2:A7344,">=1/1/2013",A2:A7344,"<=1/31/2013",B2:B7344,"BMX1RG")

#### sperling1349

##### New Member
Wow! Something that simple! It worked like a charm! I don't know how many times I retyped and copied and pasted but that fixed the problem. Thank you very much.

Replies
6
Views
127
Replies
4
Views
124
Replies
3
Views
129
Replies
1
Views
198
Replies
1
Views
150

1,195,623
Messages
6,010,749
Members
441,567
Latest member
Flitbee

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