ok i want to do some book keeping.
i buy and sell stuff.
i want a to be what i bought like an item
i want b to be what i paid to get the item
i want c to be time and gas put into getting item
i want d to be additional costs like repair or parts added.
i want e to be totals of all expenses basically add b+c+d
i want f to be what i sold it for
i want g to be total profit or loss
i want 3j to add all of b
i want 4j to add all of c+d
i want 5j to add all of f
i want 6j to add all of g

i learned all of this at some point but now i don't remember anything.
i used to be really good at it. i guess if you don't use it you
forget.
i know how to write the formula, i mean its simple enough
i want to know how the damn copy, paste, and cut functions work in
this damn environment

i have office 03
i tried for like 1 hour trying to get a formula to go down 1 entire
column i couldn't do it.

also if i can get a access data base that just takes in all this info
as well. that would be great.

please help me. go in super baby steps i know how to use computer
quite well, just not office apps.

thanks.

I assume that in 1st Row you are having Headers and your data starts from 2nd
Row.

I want e to be totals of all expenses basically add b+c+d
In E2 cell paste the below formula
=SUM(B2:D2)
Now copy the E2 cell and paste it to the remaining cells of E Column.

I want g to be total profit or loss
In G2 cell paste the below formula
=IF(OR(E2="",F2=""),"",F2-E2)
Now copy the G2 cell and paste it to the remaining cells of G Column.

I want 3j to add all of b
In J3 cell paste the below formula
=SUM(B:B)

i want 4j to add all of c+d
In J4 cell paste the below formula
=SUM(C:D)

i want 5j to add all of f
In J5 cell paste the below formula
=SUM(F:F)

i want 6j to add all of g
In J6 cell paste the below formula
=SUM(G:G)

I am not clear about this €œI want c to be time and gas put into getting
item€�, whether the C Column will have only the cost value or something like
Time and Cost of the gas?. So for me some more clarification is required
about the C Column Data.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"kavor" wrote:

ok i want to do some book keeping.
i buy and sell stuff.
i want a to be what i bought like an item
i want b to be what i paid to get the item
i want c to be time and gas put into getting item
i want d to be additional costs like repair or parts added.
i want e to be totals of all expenses basically add b+c+d
i want f to be what i sold it for
i want g to be total profit or loss
i want 3j to add all of b
i want 4j to add all of c+d
i want 5j to add all of f
i want 6j to add all of g

i learned all of this at some point but now i don't remember anything.
i used to be really good at it. i guess if you don't use it you
forget.
i know how to write the formula, i mean its simple enough
i want to know how the damn copy, paste, and cut functions work in
this damn environment

i have office 03
i tried for like 1 hour trying to get a formula to go down 1 entire
column i couldn't do it.

also if i can get a access data base that just takes in all this info
as well. that would be great.

please help me. go in super baby steps i know how to use computer
quite well, just not office apps.

thanks.
.