3d mapping complex formula

[Ronderbecke]

I was hoping someone could help with this (maybe it's not even possible?), but currently I have a formula that I can use that works perfect with sumproduct:

=SUMPRODUCT(IF(MOD(ROW('Travis Jones'!C12:C)-ROW('Travis Jones'!C12),12)=0,IF(ISNUMBER('Travis Jones'!C12:C),IF('Travis Jones'!H7:H="Stacie Getsinger",IF('Travis Jones'!C12:C-DAY('Travis Jones'!C12:C)+1=DATE(2017,7,1),'Travis Jones'!C4:C<>0)))))

The problem is that I have to redo 'Travis Jones'! 28 times and that number will continue to increase and I have to add every time it goes up and I use this formula quite a bit. Is there a way to make it do this exact same formula but across all the sheets?

I have already tried:

=SUMPRODUCT(IF(MOD(ROW('Travis Jones:Dustin White'!C12:C)-ROW('Travis Jones:Dustin White'!C12),12)=0,IF(ISNUMBER('Travis Jones:Dustin White'!C12:C),IF('Travis Jones:Dustin White'!H7:H="Stacie Getsinger",IF('Travis Jones:Dustin White'!C12:C-DAY('Travis Jones:Dustin White'!C12:C)+1=DATE(2017,7,1),'Travis Jones:Dustin White'!C4:C<>0)))))

That doesn't work. (Travis jones is the 1st sheet in a long line of sheets and Dustin White is the last one.

Is what I am looking to do even possible or do I just have to type in the formula a bunch of times which is extremely time consuming?

 

[XOR LX]

Are you using the formula I posted in Excel, or your attempt at an equivalent to that formula in Google Sheets?

Regards

 

[Ronderbecke]

I used your exact formula that you posted (it should operate on the same principle in google sheets as it does in excel to at least see what it produced.

 

[XOR LX]

You could try using the Evaluate Formula tool (or equivalent) and trying to see where the issue lies. Other than that, without seeing an actual workbook I'm afraid it's going to be difficult for me to help you further.

Regards