The criteria in this case is “FR,” which is what we want Excel to find in the range F6:F43. The sum_range is E6:E43 because it contains the amounts to be summed. Put together, the formula is =SUMIF ...

Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data. In Excel, functions are simple formulas ...

M any use Excel for basic tables, but you need to go beyond simple sums. If your formulas are getting clunky, conditional ...

Robynne Sisco, CFO, Workday “SUMIF is my favorite spreadsheet function. I find the ability to sum only certain numbers in a column if they meet certain criteria fascinating.