Extracting values for joint account holders

[pdotc]

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

[Fotis1991]

A simple way could be this.

Assuming your data start in A1, then in D1 and copy down.

=COUNTIF($A$1:A1,A1)

Then this formula, will gives you your result.

=SUMIF(D1:D4,1,C1:C4)