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

Nic Larsen

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

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

GetITDone

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