Sumifs displaying 0 for only certain months in the dataset

[jhgiants95]

I'm using the formula below trying to grab items and dollar amounts (not formatted, data came straight from a csv pull). Only the months June, September, August, and July are showing the sums. The remaining months are showing 0. I'm not sure what's causing this since it came directly from a csv file and is all formatted the same way. I did use formulas to create the month name and the year.

I converted them to values and am still having this problem. Please let me know if you have any suggestions.

=SUMIFS('Raw Data'!$H:$H,'Raw Data'!$A:$A,Summary!C$7,'Raw Data'!$B:$B,Summary!$B10)

 

[steve the fish]

It will be a problem with either what is in C7 or B10 (or wherever the formulas showing 0 are pointing) not matching the data in the columns more than likely. Hard to say as cant see it.

 

[jhgiants95]

I'm not sure how to post the table. I did try to copy the formats from the dataset to C7 and B10 and its still showing 0. But for B9,B18,B19,B20 the sums show up correctly. It seems really strange

 

[steve the fish]

What is in C7? What is in B10?

Formats are almost always meaningless. Its all about the value of the cell that matters. What you see in the formula bar.

 

[jhgiants95]

It will be a problem with either what is in C7 or B10 (or wherever the formulas showing 0 are pointing) not matching the data in the columns more than likely. Hard to say as cant see it.

I'm not sure how to post the table. I did try to copy the formats from the dataset to C7 and B10 and its still showing 0. But for B9,B18,B19,B20 the sums show up correctly. It seems really strange

What is in C7? What is in B10?

Formats are almost always meaningless. Its all about the value of the cell that matters. What you see in the formula bar.

B10 through 20 is all months in order of the fiscal year. B10 specifically is the text May no formula, and C7 is the text 19/20 no formula. C8 is 20/21 these are the two years that I'm comparing. I'm not sure why June, July, August, September, and June are working. October through may is not.

 

[steve the fish]

Ok if its just text then see if you have leading or trailing spaces in the cells. Thats first thing to try. Then look at your data and do the same. For the sumifs to work the criteria must match criteria range. You could do a test eg =A1=B10 replacing A1 with a cell you think is the same. Other thing to check is that the sum range are all numbers. Check with =ISNUMBER(A1) and drag down.

 

[jhgiants95]

Ok if its just text then see if you have leading or trailing spaces in the cells. Thats first thing to try. Then look at your data and do the same. For the sumifs to work the criteria must match criteria range. You could do a test eg =A1=B10 replacing A1 with a cell you think is the same. Other thing to check is that the sum range are all numbers. Check with =ISNUMBER(A1) and drag down.

Wow I feel really dumb now I definitely thought I checked for trailing spaces. I was staring at this for an hour before I came to ask here. I hope I didnt waste your time. Thanks for getting me to double check this. I'll definitely use all of these troubleshooting ideas in the future. Thanks again.