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!


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!