Thread: Excel Formula
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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