Using the OR function within a count formula referencing another sheet
Hey all,
Trying to work out how to add in the OR function to a count formual referencing another sheet.
Presently I've got.....
=COUNT(COLLECT({Activity}, {Row Type}, "Parent", {Status}, "Delayed"))
But the Status could be any of "Delayed", "In Progress" or "Client Delay"
Any help much appreciated!!
Thanks, Anna
Best Answer
-
Hi Anna, Unparsable is a syntax error. Usually something like a paren or comma out of place. I see 1 error, @cell has to be a lower case c.
Try: =COUNTIFS({Activity}, ISTEXT(@cell), {Row Type}, "Parent", {Status}, OR(@cell="Delayed", @cell="In Progress",@cell="Client Delay"))
If that doesn't fix it, also confirm that your range names are correct and pointed to the correct external references.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Anna Keeton ,
Try:
=COUNTIFS({Activity}, ISTEXT(@Cell), {Row Type}, "Parent", {Status}, OR(@cell="Delayed", @cell="In Progress",@cell="Client Delay"))
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Hey Mark - sadly I'm still getting unparseable with that :/. Thanks though!
Any other ideas?
-
Hi Anna, Unparsable is a syntax error. Usually something like a paren or comma out of place. I see 1 error, @cell has to be a lower case c.
Try: =COUNTIFS({Activity}, ISTEXT(@cell), {Row Type}, "Parent", {Status}, OR(@cell="Delayed", @cell="In Progress",@cell="Client Delay"))
If that doesn't fix it, also confirm that your range names are correct and pointed to the correct external references.
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 209 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!