count &sum

S

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
 
F

Frank Kabel

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

Steven Hook

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

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
 
S

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
 
Top