Forum Discussion
count if formula
IrfanLatif Both the Present and Absent columns need to be created as calculated columns and the formulas are:
Present: =IF(Day1="present",1,0)+IF(Day2="present",1,0)+IF(Day3="present",1,0)Absent: =IF(Day1="absent",1,0)+IF(Day2="absent",1,0)+IF(Day3="absent",1,0)
Which gives the following result:
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
2 Replies
IrfanLatif Both the Present and Absent columns need to be created as calculated columns and the formulas are:
Present: =IF(Day1="present",1,0)+IF(Day2="present",1,0)+IF(Day3="present",1,0)Absent: =IF(Day1="absent",1,0)+IF(Day2="absent",1,0)+IF(Day3="absent",1,0)
Which gives the following result:
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- V.Thanks
