modify array formula for additional arguments

I have an array formula below which checks that every second column on row 4 is >0 and then divides every second column in row 7 by row 12 (if row 4 was >0). However what I also need to do is only do this when those cells in row 7 and row 12 are also >0 (to prevent div/0 errors). I have been fiddling with the formula but have not been able to make it work when trying to add these additional constraints.

=SUM(IF((MOD(COLUMN($I7:$BZ7),2)=1)*$I4:$BZ4>0,($I7:$BZ7)/($I$12:$BZ$12)))

It is probably pretty easy but array formulas do my head in so it would be good if someone can assist with this.

thanks

Hi,

What version of Excel is this for? If 2007 or later, perhaps (array):

=SUM(IFERROR(1/(1/(IF(MOD(COLUMN($I7:$BZ7),2)=1,$I7:$BZ7)/($I$12:$BZ$12))),0))

Regards

You're welcome!