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
Using =SUM...just can't figure this simple thing out... 2
dragging formula is giving me undesired result in cell calls. 0
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture 1
Excel - Wich Function should I use? 1
Multiply with Vlookup value from another Worksheet 0
Calling name of Sheet as a Variable? 1
Timecard functions and formulas 1

Top