Support Board
Date/Time: Fri, 22 Nov 2024 13:37:44 +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
|