how do you use named cells in the countif function

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
COUNTIF - Summing non-numerical items in cells 5
Countif question 7
count 3
countifs Function not giving desired result with date criteria 2
Problem with foumula 1
Count entries in columns and rows 3
countif formula using named cells 3

Top