CountIfs formula- one column w/ multiple conditions and a 2nd column w/ one condition
![Lisa Matthews](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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
Best Answer
-
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
Answers
-
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
-
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
-
Lisa
I was happy to help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 61.8K Get Help
- 332 Global Discussions
- 191 Industry Talk
- 423 Announcements
- 4.3K Ideas & Feature Requests
- 130 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 446 Show & Tell
- 27 Member Spotlight
- 1 SmartStories
- 280 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!