• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Analyzing Data with Lists > Excel's List Functions

Excel's List Functions

To get more control over your list analysis, you can use Excel's list functions. These functions are the same as those used in subtotals, but they have the following advantages:

  • You can enter the functions into any cell in the worksheet.

  • You can specify the range the function uses to perform its calculations.

  • You can enter criteria or reference a criteria range to perform calculations on subsets of the list.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint