counting cells based on value

[swfarm]

hi guys

my brain has switched off completely and i need a work around
heres what i need to do

in cell a1,a2,a3,a4,a5 and a6 i have values
in a7 i need to return the count it criteria is met

so if i have the following data
a1 - 10
a2 - 2
a3 - 5
a4 - 6
a5 - 18
a6 - 11

i need to count all the cells that meet criteria

if cell a1 is <=10 then thats correct
if cell a2 is <=10 then thats correct
if cell a3 is <=10 then thats correct
if cell a4 is >=10 then thats correct
if cell a5 is >=10 then thats correct
if cell a6 is >=10 then thats correct

so if i use my example above then A7 would return the answer 5

[TMS]

Maybe

Please Login or Register  to view this content.

[swfarm]

that easy? crikey i should have known that. thanks so much

[TMS]

You're welcome. Thanks for the rep.


Always easy when you see the answer