CountIfs formula- one column w/ multiple conditions and a 2nd column w/ one condition



I am not expert in setting up formulas and would like to ask for some help with a formula I am setting up for a sheet summary field. This is what I have and it is not working:

=COUNTIFS([Primary Applicant Status]1:[Primary Applicant Status]22, "Verified income", "Applicant completed rental profile", "Signed up"), [Invalid Application]1:[Invalid Application]22, 0)

I'm trying to get a count of the 3 values in one column BUT ONLY if the value in a different column is "0" for each row.

Please, help, anyone. Thank you so much, in advance!


Best Answer


  • Lisa Matthews
    Lisa Matthews ✭✭✭✭✭


    Thank you so much!! You are FABULOUS! This worked!!!! You are correct, I wanted to look at the entire column.

    Your reply was the best news of my Monday!!!

    :) Lisa

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭


    I was happy to help.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!