Hello.
Attached is a document I'm trying to gather information for. All the actual data is in "groceries15" tab. I want a cover page to have a snap shot of the data in that tab.
I highlighted in yellow where I started to try to create a formula. I need to capture the sum of all items bought in 2015 listed on the left (column A).
I've done countifs but not sumifs.
When "almonds" is listed in the "groceries15" tab for the year 2015 sum that amount. Then hopefully the formula allows me to just click on what i'm trying to find so that I can easily copy down. I know some formulas can be set up so I could copy down & across and capture the correct information if the $ signs are in the right spot (i can figure that part out).
Thanks
Bookmarks