| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula works in google sheets but not in Excel, how to make it works? | Excel Programming | |||
| How do i apply the same formula for different cells in excel? | New Users to Excel | |||
| How do I open Excel files in Word Perfect 12 so they function? | Excel Discussion (Misc queries) | |||
| How do you make an excel worksheet cell a perfect square | Excel Discussion (Misc queries) | |||
| VB Code Works Perfect...but Not when the File is Shared | Excel Programming | |||
Linear Mode
