Help with multiplication formula

  • Thread starter Thread starter Josh W
  • Start date Start date
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
 
1. iN CELL e20
=SUM(D1:D20)*3

2. Use SUM itself

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

If this post helps click Yes
 
Back
Top