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

Lisa Matthews · 12/05/20

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 · 12/06/20

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 · 12/06/20

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 · 12/08/20

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 · 12/08/20

Lisa

I was happy to help.

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

Best Answer

Answers

Help Article Resources

Categories