Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Im trying to make a budget sheet! NEED HELP
Hi, im a new user to excel. Im trying to make a budget sheet. What I would
like to do is to be able to input in a number, say when i go out and fill up my gas tank. I would like to be able to input this number into excel and then have it continually add up the ammount of times i fill up. I know how to do this by totalling but instead of having to add up all the times i need to fill up, if i could input this in daily while excel creates a total it would be amazing. Can anyone help me. Thanks I guess im looking for this Input ---------- Total 5.00-------------5.00 monday 10.00----------- 15.00 tuesday 60.00-----------75.00 wednesday |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Im trying to make a budget sheet! NEED HELP
Hi Mike,
To achieve the following: A B C 1 Day Input Total 2 Monday 7.00 7.00 3 Tuesday 9.00 16.00 4 Wednesday 5.00 21.00 5 Etc. Type in Cell C2 '=B2' (without quotes) In C3 type '=IF(B3="","",C2+B3)' then copy this formula down the rest of the C column as far as you want to go. Sandy "mike" wrote in message ... Hi, im a new user to excel. Im trying to make a budget sheet. What I would like to do is to be able to input in a number, say when i go out and fill up my gas tank. I would like to be able to input this number into excel and then have it continually add up the ammount of times i fill up. I know how to do this by totalling but instead of having to add up all the times i need to fill up, if i could input this in daily while excel creates a total it would be amazing. Can anyone help me. Thanks I guess im looking for this Input ---------- Total 5.00-------------5.00 monday 10.00----------- 15.00 tuesday 60.00-----------75.00 wednesday |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Im trying to make a budget sheet! NEED HELP
Put this in C1 and copy it down: =SUM($B$1:B1) -- Lilliabeth ------------------------------------------------------------------------ Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741 View this thread: http://www.excelforum.com/showthread...hreadid=508587 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make multiple copies of a sheet in a new workbook | Excel Worksheet Functions | |||
Can I make a list, on one summary sheet, of data collected from ma | Excel Worksheet Functions | |||
I need a shortcut to make a excel file open to a specific sheet | Excel Discussion (Misc queries) | |||
how do i make a monthly expense spread sheet | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions |