Hello! I need help with a formula, experience with Countifs OR AND formula?
I am not sure if I am doing this right, I need to count "reference another sheet" if status is closed, completed OR sent to contractor (any of them), AND program is "APD".
Here is my formula:
=COUNTIFS(OR({Classification Review Status}, "Completed", {Classification Review Status} = "Closed", {Classification Review Status} = "Sent to contractor"), AND({Classification Review Program}, "APD"))
It says Invalid Data Type, I am not sure if I can use this formula when reference to another sheet
Answers
-
Hey @Paola Preciado
Try this
=COUNTIFS({Classification Review Status},OR(@cell= "Completed", @cell= "Closed", @cell= "Sent to contractor"), {Classification Review Program}, "APD")
Will that work for you?
Kelly
-
That worked! Thank you So much Kelly!
Paola
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!