L3 | search
Click here to view L3 news from 60+ newspapers.
Bookmark or Share- Use the SUM function to sum numbers in a rangeYou can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.
- XLOOKUP function - Microsoft SupportUse the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.
- SUMIF function - Microsoft SupportYou use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5.
- SUBTOTAL function - Microsoft SupportReturns a subtotal in a list or database. It is generally easier to create a list with subtotals by using the Subtotal command in the Outline group on the Data tab in the Excel desktop application. Once the subtotal list is created, you can modify it by editing the SUBTOTAL function.
- IF function – nested formulas and avoiding pitfallsIF function – nested formulas and avoiding pitfalls. Applies To. The IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False. =IF (Something is True, then do something, otherwise do something else)
More
