Sounds like a job for SUMIF.

Suppose the list of categories is on the Summary sheet in A2:A20 and
the register sheet is named Register and contains categories in column
B and values in column C.

In B2 in the Summary sheet put the formula =SUMIF(Register!B:B, A2,
Register!C:C) and you should see the sum for the first item on the
category list.

Copy the formula down as far as B20.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup