but Doms is better

--
Don Guillett
SalesAid Software

"Sam via OfficeKB.com" <u4102@uwe wrote in message
news:5ef86900f7a7c@uwe...
Hi Don,

Thank you very much for your time and assistance - explanation of Formulas
much appreciated.

Cheers,
Sam

Don Guillett wrote:
This is looking in col A for text it can't find to find the last row
subtracting 4 and 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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200604/1