Formula Question

[raharr]

I have a spreadsheet the contains different locations and students that
have either passed or failed a test. Columns c2-c146 contain the name
of the students location and columns d2-d146 contain the words pass or
fail. I can do a formula for counting the number a student at a
location or how many passed or failed. I used
=COUNTIF(C2:C146,"Bennettsville") for counting how many students at
that location and =COUNTIF(D2146,"Pass") for counting students that
passed from every location. I want to combine them to find out how
many passed or failed at a given location.

Suggestion?

Thanks
Russell

 

[Don Guillett]

use sumproduct. modify to suit. Rnage size must be the same.
=sumproduct((rngA="b")*(rngB="P"))

 

[Bob Phillips]

=SUMPRODUCT(--(C2:C146="Bennettsville") ,--(D2146="Pass"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[raharr]

Thanks. That did it.

Rus