C
Copi J
In Excel, I have 3 worksheets that have the same column headings with data
occurrences indicated by the letter “X†in the cells.
On a 4th worksheet, I want to show a running total of each column found on
the previous 3 sheets.
On the 4th sheet I need to show each total in a separate row because each of
the first 3 sheets are for different site locations and I want to see each
site’s information separately as well.
I additionally want to be able to total the reported results on sheet 4 for
each column.
Can anyone help me accomplish this task?
occurrences indicated by the letter “X†in the cells.
On a 4th worksheet, I want to show a running total of each column found on
the previous 3 sheets.
On the 4th sheet I need to show each total in a separate row because each of
the first 3 sheets are for different site locations and I want to see each
site’s information separately as well.
I additionally want to be able to total the reported results on sheet 4 for
each column.
Can anyone help me accomplish this task?