LinkBack URL
About LinkBacks
put the following formula in cell D2:
You'll have to change Sheet2!$B$2:$B$18 by your actual product range
=SUMIF(Sheet2!$B$2:$B$18,Sheet1!$A2,Sheet2!$A$2:$A$18)
You'll also have to change Sheet2!$A$2:$A$18 by your actual units ordered range.
put the following formula in cell D2:
You'll have to change Sheet2!$B$2:$B$18 by your actual product range=SUMIF(Sheet2!$B$2:$B$18,Sheet1!$A2,Sheet2!$A$2:$A$18)
You'll also have to change Sheet2!$A$2:$A$18 by your actual units ordered range.
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks