It sounds like you may need SUMIF (check excel's help) or SUMPRODUCT (a good
read on SUMPRODUCT can be found at the following link)

http://xldynamic.com/source/xld.SUMPRODUCT.html

"Moy Emrick" wrote:

How do I add several $ amounts using the same vlookup reference like "data?"
Is there a way to add a sum formula in the field?