Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel functions?????????FIRST TIMER
Not exactly sure what you're trying to do but I think you
are trying to have a total for the sales in each cell. Here's what you can do to make it add in a cell: =1+1+1 In the cell it will say 3. If you are entering cells in separate cells and want to total at the end, enter a sum function at the end of your data: =sum(A1:A10) Cells A1 through A10 would be added together. Hope that helps. JC -----Original Message----- I don't know exactly where I should be so here goes; I'm trying to make a menu tracking sheet and at the end of every night I go thru the checks and add every thing we prepared/sold for the day. I obviously have all items in the sheet so I go to the corressponding box and type "1" in the box. MY problem is everytime I go back to the box and add "1" it makes it 11 then 111 and so on. I need it to make it 2 3 4 5 and so on. The way I have it now is I have to highlight each box and change the number automatically. PLease help my boss is hounding me for about 6 weeks now. Also how do I find any responses I may have? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timer in Excel | Excel Discussion (Misc queries) | |||
how to create a timer in excel | Excel Discussion (Misc queries) | |||
Pop up timer for excel | Excel Discussion (Misc queries) | |||
EXCEL TIMER CONTROL | Links and Linking in Excel | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) |