View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default Index, Match, Sum??

In cell B1 of Worksheet B, enter this formula:

=SUMIF('Worksheet A'!A$1:A$100,A1,'Worksheet A'!B$1:B$100)

I've assumed you have 100 entries in worksheet A - adjust the cell
ranges as appropriate.

The formula can be copied down column B, to give you the totals from
sheet A against each ID number.

Hope this helps.

Pete