Average non contiguous row
try:
=AVERAGE(IF(MOD(COLUMN($D$3:$M$3),2)=0,IF($D$3:$M$ 30,$D$3:$M$3)))
Change ranges to suit
Enter with Ctrl+shift +Enter (array formula)
"Scott Kieta" wrote:
You are right these are columns, and yes these are alternate columns. The
main goal is to make sure the formula omits those zero values when doing the
average calculation.
"Toppers" wrote:
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?
|