How do I multiply Column G Totals by a number and display the res.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel, how do I multiply Column G Totals by a number and display the
results (sum) in Column H?
Thank you for the help
 
In H1 =G1*7

and copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
In Cell H1 enter
=SUM((G$1:G$1000)*2) <<type this in and hold down Control key + Shift key
and then press the Enter key.
This action will change the appearance/content of H1 to
{=SUM((G$1:G$1000)*2)} making it an Array entered.
Change 1000 and 2 (above) to whatever,,,
 
You must log in or register to reply here.

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

Multiplying 2 columns with IF 1
Macro to add numbers in a text string 5
Column multiplied by a matrix 2
Problem with SUMIF 3
Count total balance using two numbers 5
Sum Total 2
Conditional SUBTOTAL in XL210 Table 7
Leave Blank If No Data 6

Back
Top