Sum of True/False (1/0)

08/26/21
Accepted

Hi,

I am using this formula to search a multi-select column for if that column contains "IDS".

=IF(CONTAINS("IDS", [Define Resource Needs]@row:[Define Resource Needs]@row), "1", "0")

It is returning the 0 or 1 to me just fine - but what I want is a sum of the instances of "1". This will give me a count of how many times in that column "IDS" is labeled as "true" or "1".

However, the sum function both in the sheet itself and within the Summary function in the report is only giving me "0". What am I doing wrong?


Thanks!

Best Answer

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    By wrapping your numbers in quotes, you are outputting text strings that just look like numbers. Try removing the quotes from around the one and the zero in your IF statement and see if that does the trick for you.

    thinkspi.com

Answers

  • Paul NewcomePaul Newcome ✭✭✭✭✭
    Accepted Answer

    By wrapping your numbers in quotes, you are outputting text strings that just look like numbers. Try removing the quotes from around the one and the zero in your IF statement and see if that does the trick for you.

    thinkspi.com

  • Emily WildbergerEmily Wildberger ✭✭✭✭

    Thank you so much! This is great!

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Happy to help. 👍️

    thinkspi.com

Sign In or Register to comment.