View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
still_learning still_learning is offline
external usenet poster
 
Posts: 1
Default adding totals on item number match

Hello,

I'm sure this is simple for someone: I have a list of items with counts.
On the last row for a particular item, I want to add up the counts for each
previous matching line and create a new 'total'. Some items have only one
row, others have upto 4 with counts in each. I want one row per item with a
total count in a new column, added at the end. I've searched help and I'm a
little confused about the best way to approah this.