Reply to thread

Message: [QUOTE="Karin, post: 3795174"] I would like to average an array of cells, but only include those cells whose cell value is greater than zero. I have an array like (D3;G3;J3), and want to include only those AVERAGE(D3;G3;J3). I have tried to use SUM(D3;G3;J3)/COUNTIF((D3;G3;J3);">0" ) but the COUNTIF doesn't allow that arrayform (D3;G3;J3). If I for example put COUNTIF((D3:D7);">0") , that works - but that's not the cells where my data is! How should I write the array so that it works? Yours Karin [/QUOTE]