{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 老娘就宠你 的问题《In Excel, how to multiply ranges》','https://www.manongdao.com/q-934243.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
In Excel, I want to know how to multiply one range of cells (say A1:F10) by another range of cells (static range say H1:M10) then put the answer in one cell only (say Cell P1) .... then move down one row and multiply the new range (say A2:F11) by the same static range (say H1:M10) then put the answer in the cell below the first answer (say P2) and so on....
When multiplying I need A1 to multiply by H1, B1 multiplied by I1, A2 multiplied by H2 and so on...
I have no clue, please thank you for your help... For info my range is a range of 2800 cells by 2800 cells so fairly large. Is there a way of doing this in Excel or do I need to use VB? thank you so much...
You can use Sumproduct for that. Use a relative reference for the first range and an absolute reference for the second range.
Consider the following screenshot:
The formula in cell P1 is
Copy down. In cell P2 it will change to
and so on, incrementing the rows of the first range in each row. The second range is fixed to H1 to M1 with the $ signs and will not change when copied down.