Sumif/Sumifs question
I have a sheet that lists the number of awards that have been issued since the inception of the program. I want to create a report that breaks it out by year, award level (there are 3 different levels), and sum the total of that level. I have it by year, but adding the level I have not been able to figure out. Can someone point me down the correct path?
Tags:
Answers

You'll look to something like this:
=SUMIFS([Dollar Value]:[Dollar Value], Year:Year, "2021", Level:Level, "Low")
"2021" or/and "Low" could be a reference as well if you don't want a static criteria to be your match criteria.
Jason Tarpinian  Sevan Technology
Smartsheet Aligned Partner
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!