Why does my COUNTIF for the middle row not come up with the right counts?

765 pts.
Tags:
COUNTIF statement
Excel formulas
Excel functions
Why does my COUNTIF for the middle tow not come up with the right counts?

The first on and last one are OK, but they only have one condition.

=COUNTIF(D6:D38,"<30") ' -- OK

=COUNTIF(D6:D38,"<60")-COUNTIF(D6:D38,">29") ' -- counts double?

=COUNTIF(D6:D38,"<=89")-COUNTIF(D6:D38,">=60") ' -- counts double?

=COUNTIF(D:D,">90") ' -- OK

Answer Wiki

Thanks. We'll let you know when a new response is added.

They are in each cell.

So 4 cells has each

=COUNTIF(J2:J34,”<60″) – COUNTIF(J2:J34<b>,”<=29″)</b>

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    It's hard to tell without looking at the actual data and the results you are getting. I would put each COUNTIF in a separate cell to see if they give the correct result individually.
    68,525 pointsBadges:
    report
  • Jaymz69
    I just had someone else point out to me on the two that are comparing to do this and it seems to work.
    765 pointsBadges:
    report
  • carlosdl
    I mean, put =COUNTIF(J2:J34,"<60") in one cell and COUNTIF(J2:J34,"<=29") in another cell, and check the results. Also, please let us know what you mean by 'counts double'.
    68,525 pointsBadges:
    report
  • carlosdl
    Disregard my last comments. Glad it worked.
    68,525 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following