Adding letters instead of numbers
 

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.

Adding letters instead of numbers
 

=SUM(COUNTIF(enla,{"A","B","C"}))

If this post helps click Yes
---------------
Jacob Skaria


"mits" wrote:

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.

Adding letters instead of numbers
 

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.

Adding letters instead of numbers
 

Thanks, that's perfect!

What if i wanted to break this down further and wanted to see how many males
got A-C grades. I think i'd have to use sumproduct, but don't know how to
compose this. Could you help?

many thanks


"Jacob Skaria" wrote:

=SUM(COUNTIF(enla,{"A","B","C"}))

If this post helps click Yes
---------------
Jacob Skaria


"mits" wrote:

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.

Adding letters instead of numbers
 

"m" for male..

=SUMPRODUCT((A1:A100={"a","b","c"})*(B1:B100="m"))

If this post helps click Yes
---------------
Jacob Skaria


"mits" wrote:

Thanks, that's perfect!

What if i wanted to break this down further and wanted to see how many males
got A-C grades. I think i'd have to use sumproduct, but don't know how to
compose this. Could you help?

many thanks


"Jacob Skaria" wrote:

=SUM(COUNTIF(enla,{"A","B","C"}))

If this post helps click Yes
---------------
Jacob Skaria


"mits" wrote:

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.

Adding letters instead of numbers
 

Please ignore the previous post...Try the below

=SUMPRODUCT(--(B1:B100="m"),--ISNUMBER(MATCH(A1:A100,{"a","b","c"},0)))

If this post helps click Yes
---------------
Jacob Skaria


"mits" wrote:

Thanks, that's perfect!

What if i wanted to break this down further and wanted to see how many males
got A-C grades. I think i'd have to use sumproduct, but don't know how to
compose this. Could you help?

many thanks


"Jacob Skaria" wrote:

=SUM(COUNTIF(enla,{"A","B","C"}))

If this post helps click Yes
---------------
Jacob Skaria


"mits" wrote:

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.

Adding letters instead of numbers
 

WOW! Thank you so much - you have saved me hours of work!

really really appreciate it

"Jacob Skaria" wrote:

Please ignore the previous post...Try the below

=SUMPRODUCT(--(B1:B100="m"),--ISNUMBER(MATCH(A1:A100,{"a","b","c"},0)))

If this post helps click Yes
---------------
Jacob Skaria


"mits" wrote:

Thanks, that's perfect!

What if i wanted to break this down further and wanted to see how many males
got A-C grades. I think i'd have to use sumproduct, but don't know how to
compose this. Could you help?

many thanks


"Jacob Skaria" wrote:

=SUM(COUNTIF(enla,{"A","B","C"}))

If this post helps click Yes
---------------
Jacob Skaria


"mits" wrote:

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.