Amichai Rotman wrote:
Hello,
I am trying to create a spreadsheet to keep track of my work ours.
This is what I have:
Column A - Number of hours I've worked that day - X
Column B - The amount I get paid per hour - Y
Column C - The amount I get for bus fair per day - Z
Column G - Should be the result (in currency format) of X multiplied by Y
plus Z equals T.
I was able to enter the following in column G:
=PRODUCT(A2:A30,B2:B30)
to get the result of money I get paid for the number of hours I worked.
My problem is: What do I have to write to add the amount I get for a round
trip by bus for that day. G has to be the final gross amount of money I get
paid for that month.
Thanks!
Why not write the formula just as you stated it? Enter this in G1:
= A1*B1+C1
Copy this formula in G2 through G31. To do this, click cell G1. A little
square appears at the bottom right of that cell. Move the cursor over
this little square. The cursor should become a +. Drag the little square
down to cell G31.
Finally, in H1 write this formula:
= SUM(G1:G31)
H1 will not have the final gross amount of money you get paid for a
given month. (Remember that sometimes the 31st of a month is a work day.)
Or if you want G1 to have the final gross amount, try this:
= SUMPRODUCT(A1:A31;B1:B31) + SUM(C1:C31)
SUMPRODUCT gives you the sum of all the products for X*Y, SUM gives the
sum of all the Z.
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
