Column question
 

Forgive me if this sounds stupid, but I'm trying to
multiply everything in column b with its counterpart in
column d and then add all of the sums together.

Example:

2 2
4 3
7 4
8 5
4 6
11 8

would yield 4+12+28+40+24+88=196

unfortunately I need this to extend down both columns by
about 400 cells. Does anyone know what sort of code might
be able to do something like that?

Column question
 

Hi
use
=SUMPRODUCT(A1:A500,B1:B500)

--
Regards
Frank Kabel
Frankfurt, Germany


Kura wrote:
Forgive me if this sounds stupid, but I'm trying to
multiply everything in column b with its counterpart in
column d and then add all of the sums together.

Example:

2 2
4 3
7 4
8 5
4 6
11 8

would yield 4+12+28+40+24+88=196

unfortunately I need this to extend down both columns by
about 400 cells. Does anyone know what sort of code might
be able to do something like that?