3D countifs using named ranges

[captainentropy]

Until I can get countif.3d to work I have to rely on using something like =SUMPRODUCT(COUNTIF(INDIRECT("'"&NamedSheets&"'!A:A"),"criteria").

But what if my data isn't in the exact same format across all the named sheets? What if, for example, my data is in B11:B1000 in one sheet but in B11:B450 in another? Can I count in those exact ranges?

I tried creating names for each range using the name manager and then using:

=SUMPRODUCT(COUNTIFS(INDIRECT("'"&NameA&"'"),"criteria",INDIRECT("'"&NameB&"'"),"criteria"))

but that just gave me a #REF! error.

Any idea if I can do what I'm trying to do?

Thanks!

 

[captainentropy]

Awesome. Seems so obvious now hahaha.

 

[captainentropy]

Awesome. Seems so obvious now hahaha. Thanks for the help!