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

765 pts.
Tags:
COUNTIF statement
Microsoft Excel formulas
microsoft 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.
  • 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.
    78,895 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'.
    78,895 pointsBadges:
    report
  • carlosdl
    Disregard my last comments. Glad it worked.
    78,895 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.

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

Following

Share this item with your network: