| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add all "B1" cells on each worksheet?
I have automated a time sheet that copies and saves each time period in a new
worksheet. Each sheet has Regular Time, Overtime, Sick, Vacation, etc. On my home page, I would like to be able to add all of the 'Regular Time' amounts from each sheet. The individual time sheets are not created until the time sheet is completed and printed, so I can't simply write a formula to pull information from a worksheet name. In Quattro Pro (I know...Quattro what?), there was a 'bullet' function that would do this. Does anyone know of a way to sum all of the 'B1' cells in a spreadsheet? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| different worksheet cells on same different worksheet | Excel Discussion (Misc queries) | |||
| how do i format inserted cells in protected worksheet? | Excel Worksheet Functions | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
| copy formatted (red font) cells from one worksheet to another | Excel Discussion (Misc queries) | |||
| embedding worksheet cells in another worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
