how do you use named cells in the countif function
 

i have tried =countif(a1:a31,"=passmark") where passmark is a named cell. It
doesn't work... please help!

What exactly are you trying to do.
This works fine:
=countif(a1:a31,passmark)

Unless you are trying to also use an equation with passmark.

Paul

"boofybrunt" wrote in message
...
i have tried =countif(a1:a31,"=passmark") where passmark is a named cell.
It
doesn't work... please help!

Try:

=COUNTIF(A1:A31,"="&passmark)

HTH
Jason
Atlanta, GA

-----Original Message-----
i have tried =countif(a1:a31,"=passmark") where
passmark is a named cell. It
doesn't work... please help!
.

I have results in column A. I want to count the number of results that are
equal to or greater than a variable whose value is contained in a named cell
(named: passmark)

"PCLIVE" wrote:

What exactly are you trying to do.
This works fine:
=countif(a1:a31,passmark)

Unless you are trying to also use an equation with passmark.

Paul

"boofybrunt" wrote in message
...
i have tried =countif(a1:a31,"=passmark") where passmark is a named cell.
It
doesn't work... please help!

=countif(a1:a31,"="&passmark)

"boofybrunt" wrote:

i have tried =countif(a1:a31,"=passmark") where passmark is a named cell. It
doesn't work... please help!

cheers... it works. tried it once and it didn't..... Tried it again and it
did!??

"Duke Carey" wrote:

=countif(a1:a31,"="&passmark)

"boofybrunt" wrote:

i have tried =countif(a1:a31,"=passmark") where passmark is a named cell. It
doesn't work... please help!