Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column question | Excel Worksheet Functions | |||
Column question... | Excel Worksheet Functions | |||
Reference column question | New Users to Excel | |||
Sum at end of column question | New Users to Excel | |||
Beginners question: VAT Column | Excel Worksheet Functions |