Forum Discussion

sunilkumarkhanapure's avatar
sunilkumarkhanapure
Copper Contributor
Dec 09, 2022
Solved

Count based on column drop down text

Hi,    In my SharePoint list, I have 10 dropdown columns. (Accept, N/A, & Pending) is the selecting value in each column drop-down.   I would like to count the Total accept, Total N/A, and Total ...
SharePoint Online
  • RobElliott's avatar
    RobElliott
    Dec 09, 2022

    sunilkumarkhanapure you'd need a calculated column for each of the Accept, N/A and Pending and the formula in each would be like this:

    =IF(Column1="Accept",1,0)+IF(Column2="Accept",1,0)+IF(Column3="Accept",1,0)  etc etc for all the columns. 

     

    Then do the same for N/A and Pending:

     

    =IF(Column1="N/A",1,0)+IF(Column2="N/A",1,0)+IF(Column3="N/A",1,0)

     

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

     

     

RobElliott's avatar
RobElliott
Silver Contributor
Dec 09, 2022

sunilkumarkhanapure you'd need a calculated column for each of the Accept, N/A and Pending and the formula in each would be like this:

=IF(Column1="Accept",1,0)+IF(Column2="Accept",1,0)+IF(Column3="Accept",1,0)  etc etc for all the columns. 

 

Then do the same for N/A and Pending:

 

=IF(Column1="N/A",1,0)+IF(Column2="N/A",1,0)+IF(Column3="N/A",1,0)

 

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

 

 

Resources