C
Chris
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
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