ExcelBanter - Excel Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Formula (https://www.excelbanter.com/excel-discussion-misc-queries/21961-excel-formula.html)

SAMSON

Excel Formula

Hello guys can you help

If I have rows b1 to b60 and columns a,b ,c,d .. and I want to do the following

= (b3*d3) + (b4*d4) and so on and total it at the end how can I do it

JE McGimpsey

One way:

=SUMPRODUCT(B3:B60,D3:D60)

In article ,
SAMSON wrote:

Hello guys can you help

If I have rows b1 to b60 and columns a,b ,c,d .. and I want to do the
following

= (b3*d3) + (b4*d4) and so on and total it at the end how can
I do it

SAMSON

Thankyou McGimpsey for your quick reply appreciated, and the frormula also works

All times are GMT +1. The time now is 08:48 PM.