Assume you have a list of Tone PN in column B, with the first number in B300
under number of printers (assume formula is in C300)

=countif(B1:B290,B300)

I can't say where you would get the model number from

An alternative might be to select your data and create a pivot table report
under the Data menu. This should build the count you want.

--
Regards,
Tom Ogilvy

"DarkHound" wrote in message
...
I have a spreadsheet that I'd like to create a quick summary for. Cell B
has my printer model number and cell D has the part number for the
toner cartridge. Basicly I want to add up all the like items in column
B and display at the end of the sheet display the item name and how
many there are along with the part number for the toner in the
following format.

Model Number Toner PN #of Printers



Can anyone help me with this? I've been banging my head on it for a
while, and I'm sure there's got to be a way to do it.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/