Forum Discussion

IrfanLatif's avatar
IrfanLatif
Copper Contributor
May 27, 2022
Solved

count if formula

SharePoint Online
  • RobElliott's avatar
    RobElliott
    May 27, 2022

    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)

RobElliott's avatar
RobElliott
Silver Contributor
May 27, 2022

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)

IrfanLatif's avatar
IrfanLatif
Copper Contributor
May 27, 2022
V.Thanks