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