Over years of working with Excel, I have stumbled upon a collection of functions that have transformed my workflow. These aren't your basic SUM and AVERAGE formulas; these are the hidden gems that ...

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