Try...

=COUNTIF(INDEX(Data,ROWS(Data)-4,1):INDEX(Data,ROWS(Data),0),Criterion)

Hope this helps!

In article <5ef5eaa85a0ae@uwe, "Sam via OfficeKB.com" <u4102@uwe
wrote:

Hi All,

I would like a Formula that uses an Input cell (to accommodate changing
Numeric Criterion) Summing the Count of a Numeric Criterion in the LAST 5
Rows of a Dynamic Named Range "Data". Named Range "Data" spans 8 Columns and
many Rows.

Thanks
Sam