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.
Bookmarks