Sharepoint Online List: Column Formulas: Counting Yes/No answers in a numeric column

James Purcell 21 Reputation points


I have four columns of the Yes/No type, I would like to create a 5th column that counts the number of yes. I have seen other answers but I can not make the code work, I keep getting a syntax error. I added the column names with the picker, I have set the output to number. I tried code with =true in the test part of the formula. Can anybody help please? I believe that I can treat the Yes/No columns as boolean.

IF([Finanzielle Sanktionen],1,0)+IF([Geschätzter Gesamtwert 'Velocity'/Aufwand],1,0)+IF([Gibt es eine bestimmte vertragliche Go Live Ziele],1,0)+IF([Nicht standardmäßige Anforderungen],1,0)



A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,823 questions
SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,576 questions
0 comments No comments
{count} votes

Accepted answer
  1. Echo Du_MSFT 17,116 Reputation points

    Hello @James Purcell ,

    Please following steps:

    1) Create a Calculated field named "Count"

    2) Use the following Formula:

    =IF([Y/N],1,0)+IF([T/F],1,0)+IF([T or F],1,0)+IF([Y or N],1,0)  

    3) Select Number as the data type returned from this formula

    4) OK button



    Echo Du

    Updated Answer ==============

    Hi @James Purcell ,

    I run the test again, and this time I will follow your naming requirements to name these columns.



    Create a Calculated column named Count. The formula is as follows:

    =IF([Finanzielle Sanktionen],1,0)+IF([Geschätzter Gesamtwert 'Velocity'/Aufwand],1,0)+IF([Gibt es eine bestimmte vertragliche Go Live Ziele],1,0)+IF([Nicht standardmäßige Anforderungen],1,0)   


    I suggest that you judge in turn according to the order in which the columns are created.


    Echo Du


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
  1. James Purcell 21 Reputation points


    Thank you for your detailed reply, I believe I have followed your guide step by step, but I am still receiving a syntax error.


    I have entered the following data, I thought I would test to see if I could get it working with just one column first:


    The column layout is as follows


    And the column settings are:


    I did change the setting to allow management of all content types so that I could change the title column from being required, but I changed that back afterwards.

    Thank you again for your time and help.

  2. Gerardo Lewis 0 Reputation points

    how di you resolved it doesent work for me ?

    0 comments No comments