how to prepare formulae

R

Rama

I want to prepare a formula which will automatically multiply the numbers in
corresponding rows and finally gives the total of all the rows. Pls. respond
by mail.

Thanks,
Rama
 
T

Toppers

Multiply by what?

Say in column C:

=A1*B1 will multiply A1 by B1. Copy this formula down and you wil get =A2*B2
etc

=A1*$B$1 (copied down) will multiply ALL rows by the value in B1 i.e. by a
constant

=SUM(C1:C100) will sum the values in cells C1 to C100

Is this what you require? If not, post an example.
 
B

Billy Liddel

Rama

If you want to muliply two columns without showing each rows product use
SUMPRODUCT, e.g =SUMPRODUCT(B3:B6,C3:C6)

Regards
Peter
 
Top