• 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.17, the list beneath the summary table is filtered. You can apply the SUBTOTAL function to sum the visible cells of a filtered list.

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