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