In my Excel file I have 4 columns. In column "A" I have a text field. The values in this text field may repeat 1 or more times in the rows but the file is sorted by this row so they are all together. Then, in a 5th column I want to sum the numeric values of the data in column "C" where the text string is the same in column A. Then I also want to do this in yet another new column, summing the values in column D where the text string is the same in column A.
Please see my sample file to see what I'm trying to do.