Rama

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

Regards
Peter

"Rama" wrote:

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