I have a spreadsheet with 4 fields. One of the fields is numeric.
If all three of the fields (string) are equal to another line, then I want to add up the estimated numbers. Basically what I want to be left with is unique values for the three string fields with a total estimated number. There is no logic to what the values in the three string fields can be - they just have to be the same, and there could be any number of records in addition.
I have been wrestling with doing loops, or even a pivot table, but am not getting exactly what I am looking for.
Any help would be greatly appreciated. I have attached a spreadsheet.
Eric
Bookmarks