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.