COUNTIFS to include cells with text
Rochelle_B
✭✭✭
I need to create a crosssheet formula that counts the number of entries for a month and if there is text in another column.
I've come up with the formula below, but I get an Incorrect Argument error:
=COUNTIFS({Review Month}, =1, ISTEXT({Critical 1}))
Where am I wrong here?
Tags:
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!