View Single Post
  #5   Report Post  
Duke Carey
 
Posts: n/a
Default

=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!