software

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.

--
Snicker''''s Mom

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

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

--
Snicker''''s Momquot;Anne Troyquot; wrote:

gt; Check the help file for summing and multiplying.
gt; Something like:
gt; In cell E3: =C3*D3
gt; In cell E2: =SUM(E3:E65536)
gt; (which will add up all of E column from E down to the last row regardless of
gt; the number of rows you use)
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;Melodyquot; gt; wrote in message
gt; ...
gt; gt; Hi;
gt; gt; I would like to multiply one cell (Hours worked) with another cell
gt; gt; (hourly wage) and get the answer in the third cell (Wage earned). The
gt; gt; other
gt; gt; variable is that I would like the Wage Earned column to add all of the
gt; gt; wages
gt; gt; earned and do that in the cell designated. As an example, I have my hours
gt; gt; worked in Column C and my hourly wage in Column D. I would like to have
gt; gt; the
gt; gt; product of these two columns to appear in Column E. I also have a formula
gt; gt; in
gt; gt; E2 that sums the numbers in Column E. This is so that I can just place in
gt; gt; my
gt; gt; hours work with the my hourly wage, have it figured for me, and then added
gt; gt; so
gt; gt; that I have a total of wages from the company I have the spreadsheet for.
gt; gt; Your help would be very appreciated.
gt; gt;
gt; gt; --
gt; gt; Snicker''''s Mom
gt;
gt;
gt;

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

quot;Melodyquot; gt; wrote in message
...
gt; This works for one cell only, which, I know that is what I asked. I was
gt; wondering if there is a way to make more then one cell multiply. In other
gt; words, the column C (Hours worked) times the column D ( hourly wage)
gt; appear
gt; in Column E. And you gave me that answer, but now I want to know if there
gt; is
gt; a way to make all cells from E5 to the end of the column do that
gt; multiplication. I know to have the sum of all in E3, but what I need is
gt; for
gt; C5 through C65536 to multiply the numbers in D5 thru D65536 and the answer
gt; to
gt; appear in E5 through E65536. Is this possible. And, Anne thanks for the
gt; split, that is what I wanted to do anyway!!!
gt;
gt; --
gt; Snicker''''s Mom
gt;
gt;
gt; quot;Anne Troyquot; wrote:
gt;
gt;gt; Check the help file for summing and multiplying.
gt;gt; Something like:
gt;gt; In cell E3: =C3*D3
gt;gt; In cell E2: =SUM(E3:E65536)
gt;gt; (which will add up all of E column from E down to the last row regardless
gt;gt; of
gt;gt; the number of rows you use)
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt;
gt;gt; quot;Melodyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi;
gt;gt; gt; I would like to multiply one cell (Hours worked) with another cell
gt;gt; gt; (hourly wage) and get the answer in the third cell (Wage earned). The
gt;gt; gt; other
gt;gt; gt; variable is that I would like the Wage Earned column to add all of the
gt;gt; gt; wages
gt;gt; gt; earned and do that in the cell designated. As an example, I have my
gt;gt; gt; hours
gt;gt; gt; worked in Column C and my hourly wage in Column D. I would like to
gt;gt; gt; have
gt;gt; gt; the
gt;gt; gt; product of these two columns to appear in Column E. I also have a
gt;gt; gt; formula
gt;gt; gt; in
gt;gt; gt; E2 that sums the numbers in Column E. This is so that I can just place
gt;gt; gt; in
gt;gt; gt; my
gt;gt; gt; hours work with the my hourly wage, have it figured for me, and then
gt;gt; gt; added
gt;gt; gt; so
gt;gt; gt; that I have a total of wages from the company I have the spreadsheet
gt;gt; gt; for.
gt;gt; gt; Your help would be very appreciated.
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; Snicker''''s Mom
gt;gt;
gt;gt;
gt;gt;