You can use the following array formula
=AVERAGE(IF(MOD(ROW(D6:D96)-ROW(D6),3)=0,IF(D6:D96>0,D6:D96)))
confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar
You can use the following array formula
=AVERAGE(IF(MOD(ROW(D6:D96)-ROW(D6),3)=0,IF(D6:D96>0,D6:D96)))
confirmed with CTRL+SHIFT+ENTER so that curly braces like { and } appear around the formula in the formula bar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks