If all cells are greater than a cutoff, then this, otherwise that

[Adamonia]

Hello everyone,

I've been trying to answer this seemingly simple line but can't get it right. I've tried looking at similar threads to no avail.

My goal: if ALL four individual values (i.e., cells J2:M2) are greater than or equal to 10000, then 1, otherwise 0. My issue has been explicating that all four values need to meet this criterion, not just one of the cells. Any help would be greatly appreciated!

[azumi]

Not sure but try this, put this on blank cells :

=IF(COUNTIF(J2:M2,">=10000")=4,1,0)

[Adamonia]

Worked like a charm--big thanks!