Sumif/Sumifs question

Dale Callaway

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?

Jason Tarpinian

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.