Hi,
You may use this formula. Also, please post a question in a new thread
=SUM(COUNTIF(enla,{"A","B","C"}))
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"mits" wrote in message
...
hi
ive got a column with grades ranging from A-G. i am trying to find out how
many A-C grades there are. ive used the following formula but its not
working.
=COUNTIF(enla,OR("A","B","C"))
where enla is my named range.
any help appreciated.