filmov
tv
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
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