1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Works perfect in excel how to apply in ghseet the same formula

    From [email protected]@21:1/5 to All on Sat Feb 29 07:07:06 2020
    SUMPRODUCT(B2:B996,SUBTOTAL(9,OFFSET(F2:F996,ROW(F2:F996)-MIN(ROW(B2:B996)),0,1)))

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)