excel formula

[adinic]

Hello. Does anyone know how to do the following thing in excel:

d5*e5+d6*e6...... and so on till 140th row. I tried the following formula: sum(d5:e5*d41:e41), but didn't work.

Thank you very much!

[Dave Peterson]

How about:

=SUMPRODUCT(D5:D140,E5:E140)





adinic wrote:
>
> Hello. Does anyone know how to do the following thing in excel:
>
> d5*e5+d6*e6...... and so on till 140th row. I tried the following
> formula: sum(d5:e5*d41:e41), but didn't work.
>
> Thank you very much!
>
> --
> adinic
> ------------------------------------------------------------------------
> adinic's Profile: http://www.excelforum.com/member.php...o&userid=31529
> View this thread: http://www.excelforum.com/showthread...hreadid=518436

--

Dave Peterson