Hello,

I'm trying to sum a set of values that are associated with IDs in an adjacent column. If the same ID is present multiple times, I only want it to count the value once. For example (I'm not sure how to make this lok like an actual table in here):

35793 36 1
15504 36 1
73360 36 1
26076 08 1
26076 08 1

Column A is the one to check for unique values (row 4 and 5 are the same number) and Column C is the one to Sum (should be 4). This chart will be 50 or so rows deep, so something that can handle that would be great. I'm assuming some kind of array would be used, but I'm not sure how to set it up. Thanks in advance.