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.
![](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FNv2Cl2xm.png&hash=5df6d3d27ccda272a1bf039d75a6d8e5)
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.
![](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FNv2Cl2xm.png&hash=5df6d3d27ccda272a1bf039d75a6d8e5)
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: