count &sum

[Steven Hook]

I need the result of a formula to show the sumber in a range of cells only
if it appears 3 or more times.
so if A1 = 3, B1=4, C1=3, D1=3, E1=1 and F1=4 I need G1 to show 3
Any ideas?
Thanks

 

[Guest]

Hi
and what do you want the formula to return if more than one number occurs 3
opr more times?

 

[Steven Hook]

It can return an error, it's for checking a series of numbers I've made to
use on scratchcards.

 

[Frank Kabel]

Hi
try
=IF(COUNTIF(A1:A100,MODE(A1:A100))>=3,MODE(A1:A100),"no match")

this returns the most common number in your range

 

[Steven Hook]

OK, I've modifyied it like this:
=IF(COUNTIF(C7:H7,MODE(C7:H7))>=3,MODE(C7:H7),"no match")
but if there are t numbers that appear more than 3 times I need it to return
an error, I wrote a reply to your previous post to this effect, but it seems
to have been lost.
Thanks for the help!
Steven