Averages and Counts from different columns

N

N Harkawat

=MIN(IF(--(A3:A9="Front")*(B3:B9<>0),B3:B9))


sonofroy said:
How do I get the Minimum for the rounds on the "Front" without it
returning
zero.

I am using the =MIN(IF(a3:a9="Front",B3:B9)) and it returns zero
Click to expand...
 
Top