Using Countif with IF statement
In my sheet I have a range I am counting which works fine.
For example: =countifs([range name},System@row)
Now I want to reference another range name the location which meets the entry in the row
I can't see to get the order of syntax correct.
Answers
-
I'm not sure I follow. Are you able to provide some screenshots for reference?
-
Thank you , but I finally figured it out.
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!