Can A Code Do This

[rockyw]

Can a code look in say column D, and look for a item number like, 100012, then add all of the amounts that are for that item that are in the same rows but in column C, and put that total in a cell like sheet 2 B2? Sounds hard but Excel does some great things when one knows how. Thanks

 

[AlphaFrog]

Put this in Sheet2 B2

=SUMIF(Sheet1!D:D, 100012, Sheet1!C:C)

 

[ajm]

Can a code look in say column D, and look for a item number like, 100012, then add all of the amounts that are for that item that are in the same rows but in column C, and put that total in a cell like sheet 2 B2? Sounds hard but Excel does some great things when one knows how. Thanks

have you tried using sumif?

=sumif(D:D,"100012",C:C)

specify the sheet names if you want the total on one page and the data is on another

 

[Tigs81]

Hi Rockyw

From the sound of it the formula sumproduct should be able handle this.
eg

=SUMPRODUCT((Sheet1!D1:D7=Sheet2!A2)*--(Sheet1!C1:C7))

Thanks
tigs

 

[rockyw]

WOW, I can't beleive a formula can do this! I am always impressed with Excel and the people that know it so well. Thanks, I think I can make this work. Many Thanks