How do I use OR function in a COUNTIFS?
Hello!
I am currently trying to use a COUNTIFS function to see how many projects are in a specific phase of development, but I only want to count those projects which are under the "Iceland" or "Iceland Foods Ltd - Retail" account to get a total view of the account.
This is currently the formula I have:
=COUNTIFS({NPD Tracker (Asia) Range 1}, [Column2]@row, {NPD Tracker (Asia) Range 2}, "iceland", {NPD Tracker (Asia) Range 2}, "Iceland Foods Ltd - Retail Account")
I can see that this is counting the projects which meet both criteria, i.e. the number of projects listed under both accounts (which is incorrect and impossible). Here my question:
How do I count projects in a specific phase of development for EITHER the iceland account or iceland foods retail account? Do I need to use an OR function, if so, where in the formula does it go?
Thanks in advance!
Best Answer
-
Try this:
=COUNTIFS({NPD Tracker (Asia) Range 1}, [Column2]@row, {NPD Tracker (Asia) Range 2}, OR(@cell = "iceland", @cell = "Iceland Foods Ltd - Retail Account"))
Answers
-
Try this:
=COUNTIFS({NPD Tracker (Asia) Range 1}, [Column2]@row, {NPD Tracker (Asia) Range 2}, OR(@cell = "iceland", @cell = "Iceland Foods Ltd - Retail Account"))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!