How do I multiply 1 cell x 1 cell and answer in 3rd cell?

M

Melody

Hi;
I would like to multiply one cell (Hours worked) with another cell
(hourly wage) and get the answer in the third cell (Wage earned). The other
variable is that I would like the Wage Earned column to add all of the wages
earned and do that in the cell designated. As an example, I have my hours
worked in Column C and my hourly wage in Column D. I would like to have the
product of these two columns to appear in Column E. I also have a formula in
E2 that sums the numbers in Column E. This is so that I can just place in my
hours work with the my hourly wage, have it figured for me, and then added so
that I have a total of wages from the company I have the spreadsheet for.
Your help would be very appreciated.
 
A

Anne Troy

Check the help file for summing and multiplying. :)
Something like:
In cell E3: =C3*D3
In cell E2: =SUM(E3:E65536)
(which will add up all of E column from E down to the last row regardless of
the number of rows you use)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
 
M

Melody

This works for one cell only, which, I know that is what I asked. I was
wondering if there is a way to make more then one cell multiply. In other
words, the column C (Hours worked) times the column D ( hourly wage) appear
in Column E. And you gave me that answer, but now I want to know if there is
a way to make all cells from E5 to the end of the column do that
multiplication. I know to have the sum of all in E3, but what I need is for
C5 through C65536 to multiply the numbers in D5 thru D65536 and the answer to
appear in E5 through E65536. Is this possible. And, Anne thanks for the
split, that is what I wanted to do anyway!!!
 
A

Anne Troy

Hi, Mom! I think this is what you want:
=SUMPRODUCT(A1:A5*B1:B5)
That formula will multiply, for instance A1 * B1 through A5 * B5, and add
them all up for you in one cell.
:)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
 

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

Top