Type in the name you want and press enter.
For example, the Subtotal command could help to calculate the cost of office supplies by type from a large inventory order. The Sum Function Sum an Entire Column Sum an Entire Row Add up Multiple.
Do one of the following: On the Formula tab, in the Function Library group, select the Math & Trig button: Choose SUMIF in the list. This tutorial covers how to add entire rows or columns in Excel. Select the cell that will contain the result. To sum cells by criteria, do the following: 1. The Subtotal command allows you to automatically create groups and use common functions like SUM, COUNT, and AVERAGE to help summarize your data. Use SUMIF if you need to sum values for a particular person or another criterion.