Below are more guides on Excel’s SUM function from our extensive range of articles. Top Excel Formulas for Speed & Performance in Large Worksheets How to Use Dynamic Arrays for Running Totals in ...

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