I'm wondering if anyone can advise me on this: I'm using MS Excel 2011 on a Macbook Pro. I have 52 sheets of data opened on the same workbook and would like to total data up from 1 particular box into a summary sheet at the end. Does anyone have any quick formula's that don't require me to go through every god damn sheet, manually adding them? Wouldn't be so bad if I had a separate mouse - but it's a complete ball ache on a tracker pad.
I've googled it - but none of the suggestions help.