how to prepare formulae

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Rama

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

Regards
Peter
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which function will shorten IF-THEN-ELSE ? 5
How do I find & replace pieces of a formula? 4
percentage removal problem 0
Excel formula questin 5
Excel Help to copy information from one row at a time to another sheet 1
Multiple Logics to be looked at 2
how do i use the roundup function 6
formula for cell merging 3

Back
Top