Summing Unique Values from 4 Columns

I have 4 columns of data. Column F contains property #, Column G contains Line of Business, Column H contains Department and Column I contains a $ Amount. I have 300 rows of this data and what I am trying to do is to sum (from column H) up all unique values for column F, G, and H combined.

So if 2 rows in different parts of the spreadsheet have as an example:

Row 1 - Property 17851 - Line of Business 11 - Department 100 $ 500.00
Row 300 - Property 17851 - Line of Business 11 - Department 100 $ 500.00

I want the $ amount in column I add up to $1000 and be able to show that in another tab so it shows 17851-11-300-$1000.00

The complicated part is I need to do that for each unique code combinations of F Through H.

Any help here would be greatly appreciated.

you need to create a pivot table with your four columns to the left of the pivot. I beleive excel 2000 limits you to 3, but anything after excel 2003 will allow all 4.

Thanks I was able to utilize the Pivot. I was originally trying to get some code to accomplish this but sometimes just as easy to simply do a Pivot.