Help with multiplication formula

J

Josh W

1) I want to do the following calculation in cell E20: total of cells D1 to
D20 multiplied by 3. What is the correct formula?
2) Also if I want to add up many RANDOM cells and then multiply the total by
one other cell, what is the quickest way?
Thanks so much. Excel 2003
 
J

Jacob Skaria

1. iN CELL e20
=SUM(D1:D20)*3

2. Use SUM itself

=SUM(a1,a3,a5,a7)*B1

If this post helps click Yes
 

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

Help with multiplication formula 1
Help with multiplication part of formula 2
Excel 2007 - Multiple If Then or Lookup 7
Calculation of weighed average 6
Excel formula questin 5
iterations? 2
Formula help? 2
Formula help 2

Top