Adding columns and categories automatically

[br015535]

I have a table with four columns Date, Category, Amount, and Description. I want to keep a total of all categories in separate fields. I know I could create a pivot table but as far as I know this would require me to create a new pivot table every time I add a new row to the table. I would like the total category fields to add up automatically when I add a new line.

I am sure there is an easy way to accomplish this.

Thanks in advance.

Example

Date----Category----Amount----Description
Feb 2    Tests       10          xxxx
Feb 3    Code        20          xxxx
Feb 4    Req         30          xxxx
Feb 5    Code        20          xxxx
Feb 6    Design      10          xxxx
Feb 7    Tests       20          xxxx

Other fields

Category-----Total
  Tests       30
  Code        40
  Req         30
  Design      10