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?
|