hi all i have 31 sheets in my excel file and i want to sum the results from this function when applied on each sheet OK to be more clear i have values of 1 to 31 written in cells from M6 to AQ6 i used to sum the formulas by repeating them and change the $M$6 to $N$6 and "1" to "2" .... etc example: 0 0 +......etc up to 31 sheets it's very long and painful method to sum and it takes a lot of time if i want to edit it so is there any way i can array this function across the 31 sheets in one move ? and i'm sorry to say i don't need macros thanks in advance have a nice day Last edited by EngMarine; Yesterday at 05:34 AM.
This question generated 8 answers. To proceed to the answers, click here.
This thread is current as of October 26, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel