So you export the relevant data into Excel, where you use the SUMIF function [SUMIF (range ... At the end of the operation, as explained above, SUMPRODUCT sums the products of the rows and reports ...

The other option is to go to the Formulas tab in the function and library group; click Math and Trig. In the drop-down menu, select SUMIF ... and Pivot Chart in Excel.

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

Microsoft Office has a number of comparison operations so you can check if a value is greater than, equal to or less than another value using the standard greater than, less than and equal symbols.

Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met ...