Stop searching. Start learning and developing your excel skills.
Macro
VBA
Formula
Function
Shortcut
Tricks
» » Subtotal with Sumproduct

Subtotal with Sumproduct

July 22, 2020 | Labels:
Formula: 

SUMPRODUCT($A2:$A10,SUBTOTAL(9,OFFSET(B2:B10,ROW(B2:B10)-MIN(ROW(B2:B10)),0,1)))
Other Excel Tutorials:
Index Function

INDEX returns a value at a given position in a range or array. INDEX (array, row_num, [col_num]) r ...

OFFSET Function

Returns a reference to a range that is a specified number of rows and columns from a cell or range ...

Managing Errors

Below are common errors in excel and their definitions: #N/A - generally indicates that a for ...

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)