Hi all,

Just wondering if someone can help me with the following issue:

I have one workbook which has 50+ worksheets - one of the worksheets is a recap of all 50+; therefore in one columns I'm summing up the total for say Revenue, now the formula I have is the following:

=+'Campaign 1 - blahblah'!C11+'Campaign 2 - blahblah'!C11+'Campaign 3 - blahblah'!C11+'Campaign 4 - blahblah'
Now the above formula continues to include all 50+ worksheets; however, when I attempt to input the above into a cell on the recap worksheet Excel keeps telling me that the formula is too long! Can someone please advise on what I can do to resolve the above issue.

Many thanks.