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

Excel in Practice

One of the most common yet misunderstood functions is the SUBTOTAL function. In Figure 14.16, the list beneath the summary table is filtered. You can apply the SUBTOTAL function to sum the visible cells of a filtered list. In this example it’s imperative you use the SUBTOTAL function instead of SUM because the SUM function adds visible and nonvisible cells.

Figure 14.16. Use the SUBTOTAL function to summarize visible cells only in a list.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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