Thread: Works perfect in excel how to apply in ghseet the same formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] shahrishin@gmail.com is offline
external usenet poster
  
Posts: 1
Default Works perfect in excel how to apply in ghseet the same formula
SUMPRODUCT(B2:B996,SUBTOTAL(9,OFFSET(F2:F996,ROW(F 2:F996)-MIN(ROW(B2:B996)),0,1)))
Reply With QuoteReply With Quote