M
mae_bear22
I am trying to add up this formula across 30 worksheets:
=SUM(('Sheet1'!R:R="Late")+('Sheet 1'!E:E='Employee Summary'!A3))
I tried doing this, but got stopped after the formula got too long:
=SUM(('Sheet 1'!R:R="Late")+('Sheet 1'!E:E='Employee
Summary'!A3))+SUM(('Sheet 2'!R:R="Late")+('Sheet 2'!E:E='Employee
Summary'!A3))+SUM(('Sheet 3'!R:R="Late")+('Sheet 3'!E:E='Employee
Summary'!A3))... Sheet 4, Sheet 5...to Sheet 30 etc...
I need to summarize the exact formula from Sheet1 to Sheet30. How can I do
this?
Thanks!
Mae
=SUM(('Sheet1'!R:R="Late")+('Sheet 1'!E:E='Employee Summary'!A3))
I tried doing this, but got stopped after the formula got too long:
=SUM(('Sheet 1'!R:R="Late")+('Sheet 1'!E:E='Employee
Summary'!A3))+SUM(('Sheet 2'!R:R="Late")+('Sheet 2'!E:E='Employee
Summary'!A3))+SUM(('Sheet 3'!R:R="Late")+('Sheet 3'!E:E='Employee
Summary'!A3))... Sheet 4, Sheet 5...to Sheet 30 etc...
I need to summarize the exact formula from Sheet1 to Sheet30. How can I do
this?
Thanks!
Mae