% of sales from repeat business

[Daniel Bonallack]

In column A I have a list of customers. In column B I
have the date they attended our event, and in column C I
have the amount they paid.

Is there a way to get the repeat business total with a
formula in one cell?

For example, if Peter Smith has attended twice, and paid
$30 each time, and Janet Jones has attended three times,
and paid $30 the first time, and $20 the next two times,
my total repeat business would be $70.

Thanks in advance for any ideas on how to set this up.

Daniel

 

[Dave R.]

Look up SUMIF in excel help it will do what you want.

 

[JMay]

With your data in cells A3:B7 (as you furnished it)
In Column C - Cell C3 enter:
=If(Countif($A$3:$A3,A3)>1,B3,0)
and copy down to C7
In D7 enter =sum(C3:C7)
HTH