Login Page - Create Account

Support Board


Date/Time: Sat, 26 Nov 2022 23:41:40 +0000



Post From: Average of non-zero values in a spreadsheet

[2013-05-09 12:23:49]
TechTrader - Posts: 116
One method NOT using the AVERAGE function.
SC spreadsheet formulas are entered in row 3.
Assuming your numbers 9634-9640-0 are in column K row 3 to row 12 (10 rows)
Type in column L, row 3 =IF(K3<>0,1,0)
Type in column M, row 3 =SUM(L3:L12)
Type in column N, row 3 =SUM(K3:K12)/M3
Column N row 3 is the average of non zero numbers in column K, row 3 to row 12 (10 rows)

Note above is untested.







Date Time Of Last Edit: 2013-05-09 12:53:42