how do you use named cells in the countif function

B

boofybrunt

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

PCLIVE

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
 
B

boofybrunt

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