I am hoping one of you can shed some light on this formula on why I am getting a value error.
=AVERAGE(INDEX(BO201:BT201,MATCH(TRUE,BO201:BT201>1,0)):BT201)
In BO through BQ are 0's and BR through BT totals 129, so the average should be 43. However, I get an error in the MATCH part and can't figure out why? Any guesses?
=AVERAGE(INDEX(BO201:BT201,MATCH(TRUE,BO201:BT201>1,0)):BT201)
In BO through BQ are 0's and BR through BT totals 129, so the average should be 43. However, I get an error in the MATCH part and can't figure out why? Any guesses?