count if formula

[IrfanLatif]

[#2 · Accepted solution]

@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)

[#3]

V.Thanks