Any reason why this does not work?
I want it to tell you how many situations exist within one or the other criteria.
Both this formula:
=CONTAR.SE.S(E:E;">120";E:E;"<139" OU F:F;">80";F:F;"<89")
Like this:
=CONTAR.SE.S((E:E;">120";E:E;"<139")OU(F:F;">80";F:F;"<89"))
It does not work.
Translating better what I want is like this: I want the total value of a table in which the values of column E are between 120 and 139 or so in column F the values are between 80 and 89. If this line has both situations as true it will only count one.
Type an if, if condition 1 = true then account 1 passes to the next reverse case checks condition 2 and if this is true account 1 and passes to next