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

Chapter 7. Using Excel Add-Ins > Using the Conditional Sum Wizard

Using the Conditional Sum Wizard

If you work with lists of data, you often need to sum values in the list, but only using values that meet certain criteria. For instance, consider the example worksheet shown in Figure 7.2.

In this example, you see a list of invoices for March listed by invoice number. Suppose you now want to calculate the total sales for a particular salesperson? There are many ways to do this, including:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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