Assuming you have column A with the names
A
1) Widget 1
2) Widget 2
3) Widget 1

and the amounts in column B
B
1) 10
2) 20
3) 10

You can use the SUMIF formula in either column C or in your totals tab
=SUMIF($A$1:$A$3,A1,$B$1:$B$3)
and drag down the formula as needed. A1 represents the type of widget you
want to sum over. You can also of course hard code this into the formula by
replacing it with "Widget 1" Or if you want to get rid of the duplicates you
can first copy over a list of unique values in the in widget list by
highlighting the column with the widget name information and go to...
Data - Filter - Advanced Filter
= click "unique records only" and "copy to another location"
then list the cell you want the unique list to start in and use that for the
2nd criteria. Drag down your formula for as many of the widget names that
you have. Hope this helps.

--
Cheers,
Michelle
"Anyone who says he can see through women is missing a lot." Groucho Marx


"EAE" wrote:

I am trying to create a cell that will count the number of widgets it finds
in a given sheet or multiple sheets, based on their name and the quantity
that is marked in an adjacent cell. I would like to have it reported at the
bottom of the sheet or better yet on a totals sheet that would have all of
the different types of widjets accounted for in their own special places.

I am using office 2007

I am greatful for any insight you may have.
--
Thank you

Eric