COUNTIFS returns zeros I am trying too count the number of wind speeds within ce
ID: 3564197 • Letter: C
Question
COUNTIFS returns zeros
I am trying too count the number of wind speeds within certain ranges that fall within directions of certain ranges, but I keep getting zeross.
For instance I have entered:
=COUNTIFS(O3:O26307, ">67",O3:O26307,"<113",Q3:Q26307,"<1",Q3:Q26307,"=1")
to count all wind directions (O column) from 68-112 degree that are less than or equal to 1 m/s. There are some, but I get zero for all of them.
and similarly
=COUNTIFS(O3:O26307,">337",O3:O26307,"<23",Q3:Q26307,"<1.4",Q3:Q26307,">1") to count all northern winds (from 338-22 deegrees) that are between 1 and 1.4 m/s.
etc.
Any suggestions??
Please and thank-you!!!
Explanation / Answer
You have a logical problem in the way you set up your formulae.
By using
..., Q3:Q26307,"<1",Q3:Q26307,"=1")
you're specifying all the roows for which the value is both equal to one and not eequal to (less than) one.
Try:
=COUNTIFS(O3:O26307, ">67",O3:O26307,"<113",Q3:Q26307,"<=1")
instead.
For the second formula, you could subtraact the set from 23-337 deegrees from the total set:
=COUNTIFS(Q3:Q26307, "<>1.4", Q3:Q26307, ">1") - COUNTIFS(O3:O26307, "<338", O3:O26307, ">22", Q3:Q26307, "<1.4", Q3:Q26307, ">1")