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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countif using multiple criteria 6
IF/COUNT/AVERAGE... Value returned is incorrect. 3
AVERAGE COLUMNS BUT NOT COUNT EMPTY CELLS 4
Average 5 columns of data skipping blank columns 10
Average problem 1
//autoaverage. 2
Lookup and average data in an unsorted list 1
min function from different columns 8

Top