Countif using the min function

B

bsnapool

Hi All

Come stuck on a formulae and hoping some one might be able to help me
out.

I am trying to count numeric values within a range, and then bring back
the smallest number, so here is what i have so far:

=COUNTIF('1'!$F12:$L12,">0")

the problem I am having is that if for e.g. 5, 5, 5 is entered within
the range, it counts this as three times, but i would only like the
formulae to count it once no matter how many numeric values are
entered.

Hope this makes sense.

Thanks

Andrew
 
B

Bob Phillips

=SUMPRODUCT((F12:L12>0)/COUNTIF(F12:L12,F12:L12&""))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

bsnapool

Thanks for your reply, but this formulae adds the different variation
of the data entered. I would just like numeric values to be counted a
1 occurence.

For example

m - 5.5
t - 6.6
w - 9.6
t JURY SERVICE
f - JURY SERVICE

I would just like the formulae to count this as once occurence, eve
though 3 days have been entered.

Hope this makes sense

Thanks

Andre
 
B

Bob Phillips

Try this then

=SUMPRODUCT(--ISNUMBER(F12:L12),(F12:L12>0)/COUNTIF(F12:L12,F12:L12&""))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top