Thread: [Solved] Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon
View Single Post
 
Old 11-09-2018, 09:32 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 553
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
I edited formula in the column counting the number of absences to:


=SUM(COUNTIF(A36:AA36,{"*X*","*C*"})*0.5)+SUM(COUN TIF($D36:$AA36,{"X X","XTIX","CTIC","XLEX","CC","CLEC"})*0.5)


While in the rows counting the daily attendance, the kilometer long formula was adited to:

=IF(OR(D$12={"Sat","Sun","NC",""}),"",$C14-SUM(COUNTIF($D$15$D$42,{"*X*","X X","*C*","CC","XTIX","CTIC","XLEX","CLEC"})*0.5 )-SUM(COUNTIF($D$15:$D$42,{"T/O","DRP"}))+SUM(COUNTIF($D$15:$D$42,{"*LE*","*TI*" ,"T/I"})))
Reply With Quote