I am wondering if there is a way to use a Pivot Table to Sum up all items by
€˜Type (in Column D), which contains the €˜Total Charge for a job (in Column
E), and then subtract out a portion that has not been paid, such as €˜Balance
Due (in Column J). Creating a PT with the Type and the Total Charge is
simple, but some clients dont pay on time and thus there may be a small
Balance Due at the end of each month. The sum in the PT is too high for some
of the accounts that are not paid on time. Is there a way to account for all
the items?


Regards,
Ryan---

--
RyGuy