For Excel pros

[OSSIE]

Hello can you please ehlp and tell me if possible can excel transfer dat from 5 different sheets to a master list, i have 5 different sheets with different names, each of this sheet contains some items that are similar to anothr sheet but different amount for each, so my question is can excel look in all five and find the item and then sum all in one master sheet for all this if so can you please help!! tahnk you

[kraljb]

So you are saying that you have 5 spreadsheets with lets say 1000 items on them each, with the same items on each sheet, but different amounts.

If you have a master list of products and want to get the sum of the amounts.. this is what I'd do (assume product id's are in column A and amounts are in column b)

=sumif(Sheet1!$A$1:$A$1000,A1,Sheet1!$B$1:$B$1000)+sumif(Sheet2!$A$1:$A$1000,A1,Sheet2!$B$1:$B$1000)+sumif(Sheet3!$A$1:$A$1000,A1,Sheet3!$B$1:$B$1000)+sumif(Sheet4!$A$1:$A$1000,A1,Sheet4!$B$1:$B$1000)+sumif(Sheet5!$A$1:$A$1000,A1,Sheet5!$B$1:$B$1000)

Hope that helps!
John Kral