Countif trouble

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. I am having a problem using a countif function that has worked previously. I have a number that is a passing score for the test I am grading in cell D53. I have all of my students scores in cells D54-D87. Then I have the total number of students that have scored at or higher than the passing score in cell D88. I had used the formula

Countif(D54:D87,"">=105

and it worked fine. But now the number that is the passing score on the test (105) changes and that is where my problem is. I thought to fix this problem I could try this

Countif(D54:D87,">=D53"

but it comes up with "0" students passing after it had counted up the dozen or so students that did in fact pass. Did I do something wrong? I need to tie the countif function into cell D53 so that when that passing score changes, the countif function will also change. Thanks for any help.
 
Hi

Try this:
=COUNTIF(D54:D87,">="&D53)

Andy.

JP said:
Hello. I am having a problem using a countif function that has worked
Click to expand...
previously. I have a number that is a passing score for the test I am
grading in cell D53. I have all of my students scores in cells D54-D87. Then
I have the total number of students that have scored at or higher than the
passing score in cell D88. I had used the formula:
Countif(D54:D87,"">=105)

and it worked fine. But now the number that is the passing score on the
Click to expand...
test (105) changes and that is where my problem is. I thought to fix this
problem I could try this:
Countif(D54:D87,">=D53")

but it comes up with "0" students passing after it had counted up the
Click to expand...
dozen or so students that did in fact pass. Did I do something wrong? I need
to tie the countif function into cell D53 so that when that passing score
changes, the countif function will also change. Thanks for any help.
 
Try this:

=COUNTIF(D54:D87,">="&D53)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hello. I am having a problem using a countif function that has worked
previously. I have a number that is a passing score for the test I am
grading in cell D53. I have all of my students scores in cells D54-D87. Then
I have the total number of students that have scored at or higher than the
passing score in cell D88. I had used the formula:

Countif(D54:D87,"">=105)

and it worked fine. But now the number that is the passing score on the
test (105) changes and that is where my problem is. I thought to fix this
problem I could try this:

Countif(D54:D87,">=D53")

but it comes up with "0" students passing after it had counted up the dozen
or so students that did in fact pass. Did I do something wrong? I need to
tie the countif function into cell D53 so that when that passing score
changes, the countif function will also change. Thanks for any help.
 
Back
Top