I have a list of items we've sold, but I wanna know exactly how much did we sell value wise between a certain dates between January 1st and third, or between first and second. I'm gonna show you a little trick we do with some ifs. Some ifs. Use the summing range of C six C. That's all of the value we want to add up. Our criteria range first is going to be paired with our criteria . So we're gonna say a six colon, a meaning the entire column from six down. And now what's our criteria ? Our criteria should be something like greater than or equal to whatever is in this B one cell. And I'm gonna show you, this is not gonna work, but I'll show you how to fix it.

So now we're going to say a six colon A is. Comma less than or equal to B two. Again, those are inclusive dates. I can delete the equal sign if I don't want inclusive dates. What's gonna happen is I'm gonna get an error . I'm gonna get a formula parse error . This is means that the formula itself is typed wrong. I need to add quotes around. The greater than or equal to and the less than or equal to. And now do you think that fixes it? No, not yet. I need one more thing, which is an ampersand between the greater than an equal to and the date itself. ampersand that and ampersand the other one, and now we get the actual value.

And we can see this is correct, and I can change these dates. I can say, okay, I only want first and second inclusive, meaning what's on the first and second, and so we can also see that this is correct. 18, 10. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.