SUMIF across multiple sheets

[excelnoob007]

In a workbook, I have a sheet called Start and another called Stop, and a variable number of sheet between them. The structure of all sheets is the same.

What I want to do is check in each sheet whether Q8 is blank or not, and if its not then add Q34 of that sheet to the sum...

Something like this:

I want to achieve this:
=If(ISBLANK(Start!Q8),,Start!Q34)
+If(ISBLANK(Sheet2!Q8),,Sheet2!Q34)
+If(ISBLANK(Sheet3!Q8),,Sheet3!Q34)
...
+If(ISBLANK(Stop!Q8),,Stop!Q34)

Please help!

[DonkeyOte]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.