First, these are non-contiguous columns not rows: second, are they alternate
D,F,H ,J etc?

"Scott Kieta" wrote:

I was looking to do an average in non contigious rows using time but ignoring
zeros, so I used formula:
=Average(if((D17,F17<0),(D17,F17),"")) but comes up #VALUE and when
utilizing CTRL+SHIFT+ENTER value returned is same D17=0:09 (custom cell
h:mm) and F17=0 (custom cell: h:mm), Is there a formula to complete this for
non contigiuos row?