Formula Question:how many passed or failed at a given location.

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(D2:D146,"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

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

--
Don Guillett
SalesAid Software
[email protected]
"raharr" <[email protected]> wrote in
message news:[email protected]...
>
> 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(D2:D146,"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
>
>
> --
> raharr
> ------------------------------------------------------------------------
> raharr's Profile:
> http://www.excelforum.com/member.php...o&userid=31852
> View this thread: http://www.excelforum.com/showthread...hreadid=515741
>

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"raharr" <[email protected]> wrote in
message news:[email protected]...
>
> 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(D2:D146,"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
>
>
> --
> raharr
> ------------------------------------------------------------------------
> raharr's Profile:
http://www.excelforum.com/member.php...o&userid=31852
> View this thread: http://www.excelforum.com/showthread...hreadid=515741
>

Thanks. That did it.

Russ