Help with multiplication formula
 

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

Help with multiplication formula
 

see response to your posting in another group

--
Regards
Roger Govier

"Josh W" wrote in message
...
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

Help with multiplication formula
 

Hi,
=sum(D1:D20)*3

for your 2nd question depends on what you want to sum, if that are 3 cells
let's say a1 b1 and c1 and the # to be multiplied by is in B10

=(a1+b1+c1)*B10


"Josh W" wrote:

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

Help with multiplication formula
 

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

2. Use SUM itself

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

If this post helps click Yes
---------------
Jacob Skaria


"Josh W" wrote:

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