It sounds like you want to use =countif()
(if each object is singular)

If you have quantities, maybe using =sumif()

Debra Dalgleish has some nice counting/summing instructions at:

http://www.contextures.com/xlFunctions01.html
and
http://www.contextures.com/xlFunctions04.html

Nixco wrote:

I am doing a worksheet. On this chart I want to track the price of an object
sold. Along with that I want to add up the number of the objects that have
been sold, by just adding up the number sold in a column. Is there a way to
do this, beside creating another column and putting a qty in it.

--

Dave Peterson