COUNTIFS returns zeros I am trying too count the number of wind speeds within ce

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")

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.