COUNTIFS & VALUE FUNCTION not providing OUTPUT

Good Evening,
I figured out how to pull out the numeric character from the A & P Deliverables column, which currently has 9. No Deliverables and 1. Partnered/hosted to pull into the Count (A&P) Deliverables - 9 Column, see below.
The issue, see next image, is I am attempting to link the numeric values that are outputted in Count (A&P) Deliverables - 9 column to another sheet to execute the COUNTIFS function to count only the outputs that equal 9 in column All Deliverables Met, unfortunately it is not working as you can see that its counting the 1 and the empty cells as 1. If I understand correctly anything that is not equal to 9 should be blank, thus why I think the COUNTIFS formula is incorrect.
Thanks for taking the time to apply your brilliant minds to the simple question.
Thanks,
NCNWInc.
Best Answer
-
Hello @NCNWIncData
Try:
=IF([Deliverables Count]@row=9, COUNTIFS([Deliverables Count]:[Deliverables Count],9),"")
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
Answers
-
Hello @NCNWIncData
Try:
=IF([Deliverables Count]@row=9, COUNTIFS([Deliverables Count]:[Deliverables Count],9),"")
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined -
Good Evening Ms. Yamada,
Thanks for using your brilliant mind on my problem!
NCNWData, Inc
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 432 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!