CountIfs formula help!
I am trying to pull a count of values with multiple criteria and it is still pulling 0's. It is not showing unparsable, rather just showing no values.
=COUNTIFS({Kaiser RAID log Range 2}, [Primary Column]122, {Kaiser RAID log Range 5}, [Column2]$122, {Kaiser RAID log Range 3}, [Primary Column]@row)
I have it referencing the items I need in the sheet and have verified it is referencing the right look up values.
Any help would be appreciated!
Answers
-
Hey @Sam29
If you have verified your ranges then verify that there isn't a mismatch of one sheet treating the data as a textstring and the other sheet treating the value as a number. Often you can tell, providing you haven't manually changed the justification on the column by seeing if one sheet has the value right justified whereas it is the opposite in the other sheet. You can also begin to eliminate your criteria from your countifs, one by one, as a test to find which criteria is causing the zero value.
Let me know what you find
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!