Try this:
![]()
=SUMPRODUCT(SUBTOTAL(109,OFFSET(C5:C30,ROW(C5:C30)-MIN(ROW(C5:C30)),0,1)),(C5:C30>0)+0)
Try this:
![]()
=SUMPRODUCT(SUBTOTAL(109,OFFSET(C5:C30,ROW(C5:C30)-MIN(ROW(C5:C30)),0,1)),(C5:C30>0)+0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks