How to return average of some non zero nos. from a column

[Dongfang]

I have pasted the question on the xls sheet itself.

Thanks in advance.

[NBVC]

If you place start and end time in B35:C35, respectively, then perhaps you can use:

Please Login or Register  to view this content.

confirm it with CTRL+SHIFT+ENTER not just ENTER so that you get { } brackets around the formula, then copy down.

Note: if you get error entering formula change all commas ( , ) to semi-colons ( ; ) and then confirm with CTRL+SHIFT+ENTER

[DonkeyOte]

I would suggest you adopt the key suggestion from your earlier thread:

http://www.excelforum.com/excel-gene...a-dataset.html

at which point a basic SUMIF/COUNTIF will suffice (based on Rows integer)

[Dongfang]

I would suggest you adopt the key suggestion from your earlier thread:

http://www.excelforum.com/excel-gene...a-dataset.html

at which point a basic SUMIF/COUNTIF will suffice (based on Rows integer)

Don can you please elaborate? thx.

[Dongfang]

Aaah, got it.
=SUMIF(range from column created, =1 (2,3 and so on), value column) divided by COUNTIF(range from coulmn created, 1 (2,3 and so on))