Count 1 row and get an average based on a score in another row
GetITDone
✭✭
Hello,
How can I use this function that I know in Excel, but in Smartsheet?
=SUM(J1:J5)/COUNTA(I1:I5)
J - column( scores ) = either a 1 or a blank cell
I - column = customer service
Thanks
Tags:
Comments
-
You can use the same formula with a slight edit. Count will not count empty cells.
=SUM(J1:J5) / COUNT(I1:I5)
-
That is what I was looking for! Thanks very much.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 352 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!