Below are three different forumlas and for each of this i want to add the formula
+((Attendance!$D$4:$AH$1000="1/2PH+1/2LOP")*0.5))) How to add please
=SUMPRODUCT((Attendance!$A$4:$A$1000=$A20)*((Attendance!$D$4:$AH$1000="LOP")+((Attendance!$D$4:$AH$1000="1/2P+1/2LOP")*0.5)))
=SUMPRODUCT((Attendance!$A$4:$A$1000=$A20)*((Attendance!$D$4:$AH$1000="P")+((Attendance!$D$4:$AH$1000="1/2P+1/2LOP")*0.5)))+SUMPRODUCT((Attendance!$A$4:$A$1000=$A20)*(Attendance!$D$4:$AH$1000="CW"))+SUMPRODUCT((Attendance!$A$4:$A$1000=$A20)*(Attendance!$D$4:$AH$1000="PH"))
=SUMPRODUCT((Attendance!$A$4:$A$1000=$A20)*(Attendance!$D$4:$AH$1000="PH"))+SUMPRODUCT((Attendance!$A$4:$A$1000=$A20)*(Attendance!$D$4:$AH$1000="GH"))
Bookmarks