Why is my SUMIF not working
In this video, learn why your SUMIF function may not be working in Google Sheets, including common pitfalls like spaces in criteria and mismatched ranges. Discover tips for using SUMIFS for better accuracy and troubleshooting techniques to ensure your formulas yield the correct results.
I'll try to help you with why your SUMIF is not working, and here's a few things to go through. So we have a SUMIF here. We have a range that we wanna look at, which is the month. And then we want to look at a criteria , which is going to be this C1 column. I could type in, in quotes, January, and then the sum range is gonna be this revenue here. Okay, so that actually does resolve, but there are some issues you may be having.
So if I go into my reference and I add a space, with data validation , I see that that's different, but you might not see that's different. If I add a space here in January, I'll get zero.
But also, this space could be inside of your criteria here, where you're looking, and you might not know that you're missing out on some numbers here.
You have to look at what is the range you're looking at, then pick the criteria that you wanna sift by or filter by, and then the sum range .
So what you need to do is, uh, select the cells , go up to Format , Number , and actually select a number here, um, as the format .
So if you see that, tho- that phrase, they're different sizes, just check that you're actually have the same exact range size.