Pivot table perhaps, or sort your data on item number and then use data /
subtotals.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Jen" wrote in message
...
I'm pulling sales per item, but sometimes the item number shows up twice
with
two different sales numbers and I want to add the two sales numbers
together
and have that total sales under the one item number. Any ideas?