That's it! Thanks, Ron!!


"Ron Coderre" wrote in message
...
If your data table starts in A1 and the data begins in row 2:

Try putting this formula in Cell E1:
=SUM(1/COUNTIF($A$2:$A$10,$A$2:$A$10)*$D$2:$D$10)

(Note: Commit that array formula by pressing [Ctrl]+[Shifr]+[Enter]

Regards,
Ron