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