There may be circumstances where you have
a list of values and want to subtotal only some of the values in the list. For
example, you would use a conditional running total in these circumstances:
To create a list that contains both
Canadian and U.S. customers.
To keep customer records sorted
alphabetically based on customer name.
To create a total of the values from
only the Canadian records.
To create a total of the values from
only the U.S. records.
In each case, create two running totals:
one to keep a running total of the U.S. records and one to keep a running total
of the Canadian records.