Adding letters instead of numbers and an additonal criteria

M

mits

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

:

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
 
J

Jacob Skaria

Try the below with "m" for male in ColB
=SUMPRODUCT(--(B1:B100="m"),--ISNUMBER(MATCH(A1:A100,{"a","b","c"},0)))

If this post helps click Yes
 
T

Teethless mama

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

shorter formula:

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

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

Adding letters instead of numbers 6
Return a value based on 2 or more columns of information 2
Adding letters instead of numbers 2
Automatic emailing Excel content via Outlook (for Student grading) 2
Count multiple criteria 7
countif using multiple criteria 6
Few questions 2
Multiple criteria - count if or sumproduct? 2

Top