SUMIF by Vendor and Date
I am new to Smartsheets and cannot figure out the formula for a particular SUMIF. Basically, I need the total by Vendor & Year. I have an incredibly long list of invoices that I've imported into Smartsheets, and want to be able to use a dashboard off of the Sheet Summary to report on the totals by Vendor for each of the last 3 years.
For example, using the chart below, how would I show that we spent $2430.00 with Alphabet in 2019, leaving out the entries from 2018 and 2020?
Help Article Resources
Check out the Formula Handbook template!