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)))
|
All times are GMT +1. The time now is 02:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com