% of sales from repeat business

  • Thread starter Thread starter Daniel Bonallack
  • Start date Start date
D

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
 
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
 
Back
Top