Excel: array function across sheets


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: =IFERROR(VLOOKUP($C14,OFFSET(INDIRECT($M$6&"!"&ADDRESS(MATCH($C14,'1'!$C:$C,0),3,4,1)),,,,100),MATCH(G$12,OFFSET(INDIRECT($M$6&"!"&ADDRESS(MATCH($C14,'1'!$C:$C,0),3,4,1)),,,,100),0)+1,FALSE),0) +IFERROR(VLOOKUP($C14,OFFSET(INDIRECT($N$6&"!"&ADDRESS(MATCH($C14,'2'!$C:$C,0),3,4,1)),,,,100),MATCH(G$12,OFFSET(INDIRECT($N$6&"!"&ADDRESS(MATCH($C14,'2'!$C:$C,0),3,4,1)),,,,100),0)+1,FALSE),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


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