Hi,

I have a spreadsheet where the a/c nos are listed in Column A. The a/c holder is listed in Column B. The a/c balance is listed in Column C.

Here's the problem: for every entry in Column B, my system will put an entry into Column C.

In the case of a joint a/c, the balance will appear twice, so a straight column sum will give me a wrong total (adding the double entries for joint a/cs).

Reference Customer Value
1234 Joe Bloggs 1000
1234 Jane Bloggs 1000
1324 Mr X 500
1324 Mrs X 500

In the case of this table, I know that the total value is 1500, but with the amount of data I have, it's not feasible to manually extract the info. Is there a formula I can use?

Thanks in advance guys.

P