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,

=OFFSET(Products!$G$1,1,0,(65536-COUNTBLANK(Products!$G:$G)-1),1)
 =OFFSET(Products!$G$1,1,0,COUNTA(Products!$G:$G)-1,1)

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?

Function CountValues(ByRef Rng As Range)

  Dim Cell As Range
  Dim N As Long
  
      For Each Cell In Rng
        If Not Cell.HasFormula And Cell.Value <> "" Then N = N + 1
      Next Cell
      
      CountValues = N
      
End Function

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)