Count function
Hi
I need help with a formula. I have a column that I want to count but only based on a values in a different column. I have tried the following formula but it's not working and I can't figure out what I am doing wrong.
=countif([Test Script #]:[Test Script #], [Pass ?]:[Pass ?], <> "N/A")
The Test Script # column is the column I'm trying to count and the Pass ? is the column that has the values of either Yes, No or N/A. If the Pass ? has a value of N/A then I don't want it in the count.
Make sense?
Best Answer
-
How about this?
=COUNT([Test Script #]:[Test Script #]) - COUNTIF([Pass?]:[Pass?], ="N/A")
Answers
-
I think you need to remove the comma before the <>
=COUNTIF([Test Script #]:[Test Script #], [Pass ?]:[Pass ?] <> "N/A")
Hope this helps!
-
Thanks, that removed the error message but it is still counting the N/A in the total count. Any other suggestions? Below is the updated formula
=COUNTIF([Test Script #]:[Test Script #], [Pass?]:[Pass?] <> "N/A")
I also tried
=COUNTIFS([Test Script #]:[Test Script #], [Pass?]:[Pass?] <> "N/A")
-
Try this instead:
=COUNTIFS([Test Script #]:[Test Script #], <>"", [Pass?]:[Pass?], <>"N/A")
This may not count properly if the Pass? column is blank - do we need to consider that?
Can you count just the items in the Pass column?
-
@ker9 - that didn't work either. Any other suggestions?
-
Can you provide detail of what type of data is in your columns or a screen shot?
Is there data in the [Pass?] column for each item in the [Test Script #] column?
-
The column type for Test Script # is a auto generated number system and the Pass column is a drop down list
-
How about this?
=COUNT([Test Script #]:[Test Script #]) - COUNTIF([Pass?]:[Pass?], ="N/A")
-
That worked!!!! Thank you so much
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!