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

About List Functions

To illustrate the list functions, consider an example. If you want to, say, calculate the sum of a list field, you can enter SUM(range), and Excel produces the result. If you want to sum only a subset of the field, you must specify as arguments the particular cells to use. For lists containing hundreds of records, however, this process is impractical. (It's also illegal, for two reasons: Excel allows a maximum of 30 arguments in the SUM() function, and it allows a maximum of 255 characters in a cell entry.)

The solution is to use DSUM(), which is the list equivalent of the SUM() function. The DSUM() function takes three arguments: a list range, a field name, and a criteria range. DSUM() looks at the specified field in the list and sums only records that match the criteria in the criteria range.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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