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

Lisa Matthews

Hello,

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!

--Lisa

Kelly Moore

Hi Lisa

Try this

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

I assumed you were wanting to look at the entire column so I did not include row numbers. If you do want the specific range, add the row numbers back.

Let me know if this isn't what you need and we can try again

Kelly Moore

Hi Lisa

Try this

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

I assumed you were wanting to look at the entire column so I did not include row numbers. If you do want the specific range, add the row numbers back.

Let me know if this isn't what you need and we can try again

Lisa Matthews

Hello,

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

Lisa

I was happy to help.