Dynamic Named Range COUNT ignore formulas

I looked around for a solution including: Dynamic range - ignoring formulas
I have array formulas (some with results, some not) that are all being referenced by the Named Range when I use either,

Please Login or Register  to view this content.

Pasting values to a new column doesn't seem make a difference, the entire column is identified (this is strange to my thinking).
1. How can I get this to work with formulas when defining the Named Range Reference, ignoring formulas with no result?
-Or-
2. How can I implement the UDF suggestion below from "Dynamic range -ignoring formulas" thread in conjunction with the Named Range formula?

Please Login or Register  to view this content.

It's good to know when to stop struggling and go with a work around, but success will feel sweeter (even if it's 100% y'all)

Thank you for the speedy reply!

Unfortunately the results are alphanumeric (providing a reference for data validation list)

It is odd that copying the column and pasting values then applying Offset/CountA didn't work.

If you are looking for a dynamic named range that reflects formula results only, try replacing your named range :
Wood =CatDet!$S$2:$S$1002 with
Wood =OFFSET(CatDet!$S$3,0,0,MATCH("*",CatDet!$S:$S,-1)-2,1)

There are good examples located at:

HTML Code: