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.
Bookmarks