I'm trying to create a formula that will count the values that are more
than 0 in a range across multiple worksheets.

COUNTIF('1:17'!D3:D9,"0") is what the "wizard" comes up with I use it but
it errs. After discovering that COUNTIF is an invalid formula function for
a 3-D reference, I'm stumped.

I would COUNTIF on each sheet and then just SUM on the master overview
sheet (named RESULTS) but I have 36 individual ranges on each sheet to
apply it to.

COUNT, of course, adds any cell with O and I need to have the 0's within
each sheet.

Is there any other way to easily accomplish this?