Login Page - Create Account

Support Board


Date/Time: Tue, 21 Jan 2025 04:10:00 +0000



Post From: Please confirm spreadsheet formula

[2018-06-27 00:07:06]
User68474 - Posts: 201
Is this the proper spreadsheet formula for summing and then averaging all the non-zero numbers, Rows G3:G1418 in Column G of a Spreadsheet Study?

AVERAGE_IGNOREZEROES(G3,G1418)

Furthermore, is the proper place to enter this Formula(or the corrected one): " In one of the available Spreadsheet formula columns, by default K through Z" (pasted from documentation) ?? If so, what cell? (i.e. (X2)?