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 ...

In the SUMIF function, by default Excel adds up the cells in the range that meet the criteria. If you want to find the sum of another range of cells rather than the range used to match the criteria, ...

A formula in Excel always begins with an equal sign (=), indicating to Excel that the following expression is intended for calculation. For instance, if you want to sum the values in two cells ...

To sum a Column in a Microsoft Excel spreadsheet, you can use the AutoSum, the Status Bar, and even the Sum function to calculate values in one or more columns ...

Another function, COUNT (), counts the cells in its range that contain numbers. Many of Excel's statistical functions also calculate the aggregate value of a range of cells.

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.