Commonly we use SUMIF function to sum data that reference to same value, static. But actually, SUMIF also can do calculation using operation like less than and greater than. How to do SUMIF use less than and greater than you can watch this video
for exercise table, please visit this link:
https://www.grexcelsheet.com/2018/07/...