In AX2:
=SUMPRODUCT(--($B5:$AM5<0.5), --($B5:$AM5>0), --(MOD(COLUMN($B5:$AM5)-1,3)=1))
In AY2:
=SUMPRODUCT(--($B5:$AM5>0), --($B5:$AM5<1), --(MOD(COLUMN($B5:$AM5)-1,3)=1)) - AX5
In AX2:
=SUMPRODUCT(--($B5:$AM5<0.5), --($B5:$AM5>0), --(MOD(COLUMN($B5:$AM5)-1,3)=1))
In AY2:
=SUMPRODUCT(--($B5:$AM5>0), --($B5:$AM5<1), --(MOD(COLUMN($B5:$AM5)-1,3)=1)) - AX5
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks