COUNTIFS to include cells with text
Comments
-
Try this, just need to update formula for cross sheet.
=COUNTIFS([Review Month]:[Review Month], =1, Critical:Critical, <>"")
=COUNTIFS({My Test Sheet2 Range 1}, =1, {My Test Sheet2 Range 2}, <>"")
-
A GODSEND YOU ARE! Thank you!!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!