Naming a cell or a range of cells in Excel is straightforward. Simply select the cell or range you want to name, and replace ...

Open your spreadsheet in Microsoft Excel. Click the cell where you wish the total sum to appear. Type "=SUM(range1,range2,range3)" into the cell and replace "range#" with a range of data.

The sum of the column of zeros will be displayed in the cell. Alternatively, you can type in the Sum function -- "=sum()" -- and the range to be summed if you are familiar with the Excel Sum function.

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