CODEWITHSUNDEEP
excel-formula
HunTer
HunTer

Reputation: 87

How to count number of students which have passed or failed in multiple subjects in Excel

I have a excel sheet like :

Sr.no___RollNumber__Subject1__Subject2__Subject3

1.-------------001-------------Pass----------Pass------Pass

2.-------------002-------------NULL----------Pass------Pass

3.-------------003-------------Pass----------Fail------NULL

4.-------------004-------------Fail----------Pass------NULL

*NULL Means Blank Cells

I want to write a single excel formula to get the count of all the students who have passed in at least 2 of the 3 subjects.

Upvotes: 0

Views: 31265

Answers (1)

Scott Craner
Scott Craner

Reputation: 152605

Use SUMPRODUCT:

=SUMPRODUCT(((C2:C5="Pass")+(D2:D5="Pass")+(E2:E5="Pass")>=2)*1)

enter image description here

Upvotes: 1

Related Questions