ExcelBanter - from a group of cells.find average of cells containing values

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - from a group of cells.find average of cells containing values (https://www.excelbanter.com/excel-discussion-misc-queries/123461-group-cells-find-average-cells-containing-values.html)

farm

from a group of cells.find average of cells containing values

average some specified cells using only those with values greater then 0

Billy Liddel

from a group of cells.find average of cells containing values

"farm" wrote:

average some specified cells using only those with values greater then 0

Hi

Try =SUM(A1:A6)/COUNTIF(A1:A6,"0") where A1 to A6 is the range

Regards
Peter

All times are GMT +1. The time now is 06:59 AM.