Cathy, see two of Chip Pearson's pages to help out. First, you want to
create a unique list of your items in column c (Extracting Unique Entries,
(http://www.cpearson.com/excel/duplicat.htm), then you want to remove the
blanks from the list (Eliminating Blank Cells From Lists,
http://www.cpearson.com/excel/noblanks.htm). This should provide the unique
list of cost centers, then you can use SumIf to total.

Regards,
Bill



"Cathy Landry" wrote:

Hello,

I have a mileage form that in col C list multiple cost centers and in col D
the user has to enter their cost center again so the calculations will work.
I'd like a formula that will pull the cost center in C only once so there is
a total of mlg being claimed per cost center.

Example:

A B C D E
10 miles 09/01 611 611 40 miles
20 miles 09/02 612 612 60 miles
30 miles 09/03 611
40 miles 09/04 612

Thank you for any/all assistance
Cathy