Formula too long
 

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

Formula too long
 

Hi,
You can enter a Subtotal formula on each worksheets in the first row, then
in you summary you will have something like this
=Sheet2!B1+Sheet3!B1


"mae_bear22" wrote:

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

Formula too long
 

Hi,

In 2003 you are limited to 1024 characters in a formula, in 2007 that limit
is 8192.

You can make your formula shorter by defining range names such as
'Sheet1'!R:R defined as S1R.
Also, if you are writing this fomula on the Employee Summary sheet then you
don't need references like
='Employee Summary'!A3
instead use =A3

You could also range name
'Employee Summary'!A3
to
EmA3

If you don't want to do this you can break up the formula into 2 cells and
then add their combined results in a third cell

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"mae_bear22" wrote:

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

Formula too long
 

Thank you!!!

"Eduardo" wrote:

Hi,
You can enter a Subtotal formula on each worksheets in the first row, then
in you summary you will have something like this
=Sheet2!B1+Sheet3!B1


"mae_bear22" wrote:

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

Formula too long
 

Thank you!!!

"Shane Devenshire" wrote:

Hi,

In 2003 you are limited to 1024 characters in a formula, in 2007 that limit
is 8192.

You can make your formula shorter by defining range names such as
'Sheet1'!R:R defined as S1R.
Also, if you are writing this fomula on the Employee Summary sheet then you
don't need references like
='Employee Summary'!A3
instead use =A3

You could also range name
'Employee Summary'!A3
to
EmA3

If you don't want to do this you can break up the formula into 2 cells and
then add their combined results in a third cell

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"mae_bear22" wrote:

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