Adding columns and categories automatically

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

Please edit your title in accordance with forum rules. We request this in order to add to threads searchable by description for people with similar questions in the future.

Something along the lines of "Sum dependant upon other columns".

If you could kindly change the name of your thread, I'll provide you with the solution you're looking for.

You're looking for a SUMIF formula. Ex:

=SUMIF(B2:B10,"Tests",C2:C10)