I have a spread sheet which looks at colour functions using both the true and false formulae in separate cells, these work fine.
What I am looking for is a formula for when it meets an instance(s) of the same cell colour and the value is greater than or equal to 10 it returns a count of 1 each time. Therefore if in my table I am using red with the following 6 instance values inside; 8,11,15,6,10,25 it returns the answer as 4.
Can anyone help?
Bookmarks