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.
|