[quote=isabelle;1602511]hi sporenta,

a pivot table would be a good solution to your problem

http://www.exceltip.com/excel_tips/E...Tables/32.html


--
isabelle


Thanks, Isabelle. I'm looking into pivot tables, and they have potential to help.

I did figure out the formula I was looking for, however. It references the card numbers and adds up all instances:

=SUMIF(A:A,(IF(ISNUMBER(MATCH(C3,A:A,0)),A3,"")),B :B)

Thanks for the reply.

Cheers,
Steve