Hi Matt,
Put this formula in D24 and copy across to E24
![]()
=SUMPRODUCT(SUBTOTAL(2,OFFSET(D2,ROW(D2:D22)-ROW(D2),,1)),$B$2:$B$22,D2:D22)
Hi Matt,
Put this formula in D24 and copy across to E24
![]()
=SUMPRODUCT(SUBTOTAL(2,OFFSET(D2,ROW(D2:D22)-ROW(D2),,1)),$B$2:$B$22,D2:D22)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks