The SUM function is too basic, use SUMIFS instead!
while you're fiddling with filters and building messy support columns, excel is waiting for you. there's a smarter function, hiding right in front of you, that can do the heavy6 Conditional Functions That Make Excel Spreadsheets Smarter
if your formulas get complex, conditional functions are a smarter choice, hidden in plain sight.Differentiate between SUM, SUMIF, SUMIFS and DSUM functions
whenever you enter a function = sum in a cell in excel, you will get a lot of functions starting with sum and wondering how they are different? this article will help you solve
