Hello,

I have been making a spread sheet which collects allot of different data and then has a summary page at the end which adds specific bits of the data up. i have managed to get it working where it just pulls from one sheet but i am now needing to get this to work across multiple sheets.

This is what i have used for a single sheet:

=SUMIFS(habitatmins, habitat, "open", time, "SS-15 to SS+30",battype, "common pipistrelle")

habitatmins = $F:$F
habitat = $E:$E
time = $A:$A
battype = $G:$G

I have tried the following but all it returns is a zero:

=SUMPRODUCT(SUMIFS(INDIRECT("'"&$M$30:$M$31&"'!$F:$F"),INDIRECT("'"&$M$30:$M$31&"'!$E:$E"), "open",INDIRECT("'"&$M$30:$M$31&"'!$A:$A"),"SS+31 to SS+60", INDIRECT("'"&$M$30:$M$31&"'!$G:$G"), "common pipistrelle" ))

where my sheet names are in M30:M31 (but will be extended to a large number of sheets)

Any help would be much appreciated.

Many thanks,

Aaron