Countifs not counting, returns #value

I'm using Countifs thusly:

=SUM(COUNTIFS(INDIRECT("'"&B$41&"'"&"!$G$4:$G$430"),">="&B$3,INDIRECT("'"&B$41&"'"&"!$G$4:$G$430"),"<"&EDATE(B$3,1),INDEX(INDIRECT("'"&B$41&"'!$P$4:$T$300"),0,MATCH($A42,INDIRECT("'"&B$41&"'!$P$3:$T$3"))),"<>"&""))

Everything works right up until it gets to the Countifs formula, then it returns the #value. Attached is the workbook. On the October page I've taken out the indirects but on the numbers sheet the formula (w/indirect) has gone awry. I've tried confirming with CSE (grasping at straws) but, of course, it didn't help. I have a feeling it's the indirect function but don't know how to correct it.

Example Maintenance Log.xls