Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all,
Got another problem: I want to create a formula so it can scan all worksheets within a workbook. For example, I have the tabs labeled Sept08 August08 July08 And within each tab, I have the same column headings Measures CaseMan Psychoed Beneath these column headings are either a 1 or 0 However, each Row within each sheet has a specific ID number. So for example: ID Measures CaseMan Psychoed 1 1 0 0 2 0 1 1 3 1 1 1 4 0 0 0 I want to sum each column heading with its corresponding ID number across the tabs listed above on a different worksheet within the same workbook. Does that make sense? Any suggestions? Thanks, Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maximunm # of Spreadsheets in any Workbook | Excel Discussion (Misc queries) | |||
Maximunm # of Spreadsheets in any Workbook | New Users to Excel | |||
Linking Spreadsheets in a Workbook | Excel Discussion (Misc queries) | |||
Linking Spreadsheets within a workbook | Excel Discussion (Misc queries) | |||
different datestamps for different spreadsheets in a workbook | Excel Discussion (Misc queries) |