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:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)