Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I have a folder with a number of identical workbooks each one saved under a different department. Each workbook contains 13 worksheets identified as Wk1 to Wk13 representing 13 weeks In week 13 I wish to identify in cell P5 the total of the contents of cell M5 in each of the 13 worksheets. I have tried several formulations but I either get an error message or it brings up the folder with all the workbooks as if I have hit the open icon. Each of the M5 cells will only have a number in it. Any help would be appreciated-- with kind regards Mick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting the total number of cells with specified condition(freque | Excel Discussion (Misc queries) | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
Adding separate accumulators for multiple cells | New Users to Excel | |||
How can I have excel search and add multiple cells to find a targe | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |