Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello all,
I have lots of worksheets, which I have named after my staff (e.g. Joe.B, Joanne.B) All the sheets are identical. The sheets are tracking individuals time on cells B6 and B7. I have another sheet called 'front sheet' that I want to display the total of all the B6's and B7's for all my staff. The problem is, is that B6 and B7 (on the employee sheets) both contain formulas and for some strange reason excel is giving me funny totals. The numbers on the employee sheets are fine but the total I get on the Front Sheet are very odd. These cells are all in time format too... If anyone can help me with this I'd be ever so greatful. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding same cells across multiple worksheets | Excel Worksheet Functions | |||
Duplicate Worksheets | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Merge Worksheets | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |