COUNTIFS to count return with 3 conditions

Kan Yang
✭
=COUNTIFS({SP Migration Sentiment Range 8),wave1,{SP Migration Sentiment Range 3}, <8, {SP Migration Sentiment Range 3},
Need help on this formula. Ultimately, need to count value between 4~7 along the value of Wave 1
Answers
-
Are you able to provide screenshots with sensitive/confidential data removed, blocked and/or replaced with "dummy data" as needed?
-
Hello Paul. I figured it out. I would just need to continue to add range, and criterion to break out the condition. Thank you for your time responding.
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!