Burrgogi
Active Member
- Joined
- Nov 3, 2005
- Messages
- 495
- Office Version
- 2010
- Platform
- Windows
I have a very simple question regarding the SUMIFS function. I've created a spreadsheet containing all of my store purchases at a local store. Examples of categories are groceries and apparel. I want to sum up all the grocery purchases in June, July, August etc...
Here is my worksheet.
In an empty cell, I've entered the following formula but it's not working.
=SUMIFS(K18:K128,G18:G128,"Groc",B18:B128,"Jun")
My guess is that the "Jun" is not a valid criteria but i don't know how to fix that because purchase dates vary.
Here is my worksheet.
In an empty cell, I've entered the following formula but it's not working.
=SUMIFS(K18:K128,G18:G128,"Groc",B18:B128,"Jun")
My guess is that the "Jun" is not a valid criteria but i don't know how to fix that because purchase dates vary.
Last edited: