=AVERAGE(IF($C$2:$C$33=0,$B$2:$B$33))

=MAX(IF($C$2:$C$33=0,$A$2:$A$33))

=MIN(IF($C$2:$C$33=0,$A$2:$A$33))

all array formulae

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Mark J" wrote in message
...

already figured out first part without pivot table using;

=SUMIF(C2:C260,0,B2:B260)



but how do i find max/min time using this function:

=INDEX($A$2:$A$260,MATCH(0,MAX($C$2:$G$260,FALSE), 1))

DateTime FIQR_5350 rank
00:29:10 113.87 0
00:29:30 292.01 0
00:29:50 471.49 0
00:30:10 483.40 0
00:30:30 489.60 0
00:30:50 494.05 0
00:31:10 492.85 0
00:31:30 485.10 0
00:31:50 491.25 0
00:32:10 476.25 0
00:32:30 487.05 0
00:32:50 330.02 0
00:33:10 314.76 0
00:33:30 320.66 0
00:33:50 325.97 0
00:34:10 319.81 0
00:34:30 327.27 0
00:34:50 333.22 0
00:35:10 326.12 0
00:35:30 500.05 0
00:36:30 499.85 0
00:36:50 142.63 0