IF Statement combined with COUNTIF Statement

Hi All,

I have a list containing 10 values in 10 separate cells, which I have split into 3 groups. I have criteria where no more than 2 cells per group can have values greater than 0.

I want to combine the formula of =COUNT(IF('RANGE'<>0, RANGE)) which only counts the cell if it has a value that isn't 0, with the formula;

=IF(COUNT(RANGE)>2,CHAR(251),CHAR(252)

Can someone advise how I can combine these 2 formulas, and also repeat 3 times for 3 groups.

I want a cross to appear if any of the 3 groups has a count of greater than 2, not just all of them.

Thanks in advance for your help.

Is this what you want?
=IF(COUNT(IF('RANGE'<>0, RANGE))>2,CHAR(251),CHAR(252)

Keeping it simple, you could use

=IF(AND((NOT(COUNTIF(RANGE1,">0")>2)),(NOT(COUNTIF(RANGE2,">0")>2)),(NOT(COUNTIF(RANGE3,">0")>2)),
OR(COUNT(RANGE1)>2,COUNT(RANGE2)>2,COUNT(RANGE2)>2)),
CHAR(251),CHAR(252))

Thanks to you both for your replies.

Bob, your layout is what I was looking for. Thanks for your help