This is looking in col A for text it can't find to find the last
rowsubtracting 4and summing that range for col B
=SUM(INDIRECT("b"&MATCH("zzzzz",A:A)-4&":b"&MATCH("zzzzzzz",A:A)))
this counts col B over 2
=COUNTIF(INDIRECT("b"&MATCH("zzzzz",A:A)-4&":b"&MATCH("zzzzzzz",A:A)),"2")
name num 20
a 1 4
b 2
c 3
d 4
e 5
f 6


--
Don Guillett
SalesAid Software

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:5ef5eaa85a0ae@uwe...
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

--
Message posted via http://www.officekb.com