Sumifs returning 0

[sperling1349]

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.

 

[barry houdini]

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]

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.