Count 1 row and get an average based on a score in another row
Options
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!