SOLVED

# count if formula

Copper Contributor

# count if formula

2 Replies
best response confirmed by IrfanLatif (Copper Contributor)
Solution

# Re: 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)

# Re: count if formula

V.Thanks
1 best response

Accepted Solutions
best response confirmed by IrfanLatif (Copper Contributor)
Solution

# Re: 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)