ive got a column with grades ranging from A-G. i am trying to find out how
many A-C grades there are. A user has helped me out with the following formula

"Jacob Skaria" wrote:

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

where enla is my named range.

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. Please could you help?

many thanks