Dear All, I have a workbook with sheet1 (name of sheet qty) and sheet2(name of sheet price) I want in Sheet2(price) i.e multiplication of qty and price cell by cell and then sum of each multiplication in a cell. i.e Qty.Sheet price sheet Cell c6:c21 c6:c21 Cell d6:d21 d6:d21 ... upto Cell j6:j21 j6:j21 and so on. I want multiply (qty C6* Price C6 then qtyC7*PriceC7 ......so on till qtyC21*PriceC21) In cell C22 sum of all this multiplication. again (qty D6* Price D6 then qtyD7*Price D7 ......so on till qtyD21*PriceD21) In cell D22 sum of all this multiplication. ... ... upto Col (qty J6* Price j6 then qtyJ7*Price J7 ......so on till qtyJ21*PriceJ21) In cell J22 sum of all this multiplication. Finally in cell F 26 Sum of all sum i.e sum(c22,d22,e22,f22,........j22) Hope my problem is clear. Please assist me either through VBA or through Formula or function or any automated technique. I have a lot of workbook and it would take time if i would do it manually. Rgds, Aligahk06
--~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
AutoMult.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
