Count 1 row and get an average based on a score in another row

GetITDone · 01/16/19

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

Capture SS.PNG

Nic Larsen · 01/16/19

You can use the same formula with a slight edit. Count will not count empty cells.

=SUM(J1:J5) / COUNT(I1:I5)

GetITDone · 01/16/19

That is what I was looking for! Thanks very much.

Comments