G
Guest
I am still having an issue with counting values:
I want to count the number of values in multiple cells that meet a condition.
Two of the conditions are:
Greater than 6 but less than 10
Greater than 11 but less than 15
The countif function only lets me calculate one time correctly.
When the countif function is used twice in the same cell, subtracting the
two answers, it gives me an answer that is one more than it should be.
An example of the function I have tried from another post is this:
=(COUNTIF(B2:B28,">=6")-COUNTIF(B2:B28,""<=10))
I want to count the number of values in multiple cells that meet a condition.
Two of the conditions are:
Greater than 6 but less than 10
Greater than 11 but less than 15
The countif function only lets me calculate one time correctly.
When the countif function is used twice in the same cell, subtracting the
two answers, it gives me an answer that is one more than it should be.
An example of the function I have tried from another post is this:
=(COUNTIF(B2:B28,">=6")-COUNTIF(B2:B28,""<=10))