SOLVED

count if formula

New Contributor
2 Replies
best response confirmed by IrfanLatif (New Contributor)
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:

IfPresentAbsent.png

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

V.Thanks