To get the same Improve result, (but not the same SUM(), try:

=IF(AND(ISNUMBER(C2),C2<MIN($B$2:B2))+AND(ISNUMBER (C3),C3MAX($B$3:B3))0,1,0)

for Wk2 and copy across. I assume that Improve for Wk1 will always be 0

For the Attend try in Wk1:

=IF(COUNT(B2:B3)0,2,0)

and copy across

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"LittleAths Volunteer" wrote
in message ...
Hi
I need help with some formulas in a worksheet which records, over 16
weeks,
all performances of an athlete while highlighting any improvements on
their
previous best and awards 1 point,and also collects 2 points for each weeks
attendance. The total of which will be used for trophies and certificates.

Wk1 Wk2 Wk3 Wk4 PB
100m 22.36 22.31 23.28 23.07 22.31
longjump 1.68 1.68 1.85 DNF 1.85
Totals
Improve 0 1 1 0 4
Attend 2 2 2 2 8

The improvement of wk4 only equals an improvement if it was better than
personal best not if it was just an improvement on the previous week.Is
this
the best way to explain what I am trying to do or is there somewhere i can
send the worksheet to get formulas added.
--
Little Athletics Volunteer
Promoting Family,Fun and Fitness