Sum Visible Cells with criteria 👌✔️

This video tutorial helpful for excel aspirants to understand retrieving sum of visible cells based on a condition.

Formula: SUMPRODUCT(($B$6:$B$10=B2)*SUBTOTAL(103,OFFSET($B$6,ROW($B$6:$B$10)-MIN(ROW($B$6:$B$10)),0))*$C$6:$C$10)

If any one have any doubt , please comment

#sumproduct #subtotal #offset
#sumvisiblecells