Count If Formula
Hi there,
I am trying to look up a WBS number from a cell in a column and count the number of times it appears in another column with the status of either "blocked", "work in progress" or "Not Started"
The first criteria seems to work (i.e. the bit that counts the blocked", "work in progress" or "Not Started"), but the second criteria fails. I want to link the 2nd criteria to a cell in a column which has a number.
Any pointers would be much appreciated.
Thanks in advance.
Nick
Best Answer
-
It looks like you need to move the curly bracket at the end to after the 1 to close out the range before starting the criteria.
Answers
-
It looks like you need to move the curly bracket at the end to after the 1 to close out the range before starting the criteria.
-
Many thanks Paul.
That worked!
Nick :-)
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!