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

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

    Jaymz69765 pointsBadges:
  • Excel VBA Count # of Cells within Max and Min in a Table

    How do you write a VBA macro that count the numbers cell within a selected table that falls between a maximum and minimum number?

    Haxel5 pointsBadges:
  • Count/Sum Question

    Hi I have a field with only 2 values. 0 and -1. I am interested in counting the -1's that occur only if they occur 4 or more times consecutively. Therefore, if the output were 0, 0, -1, -1, 0 the output would be 0. However, if it were 0,0,-1,-1,-1,-1,-1, 0, 0, -1,-1,-1,-1 the sum would be 9. Help...

    Chhmusic15 pointsBadges:
  • COUNTIF command using Excel and s comma-delimited file

    I saved a comma-delimited file to my excel 2003 worksheet and had a problem using the countif command. It wouldn't recognize the text info. For example, countif(xx:xx,"abc"), it wouldn't recognize the abc cells. Can you help me?

    Cklv5 pointsBadges:
1

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