一條咁長又重覆嘅SUMIF公式點樣靠SUMPRODUCT簡化呢?
=SUMIF($A$2:$A$16,F3,$B$2:$B$16)+SUMIF($A$2:$A$16,F3,$C$2:$C$16)+SUMIF($A$2:$A$16,F3,$D$2:$D$16)
一齊睇睇教學片詳細講解啦!
一條咁長又重覆嘅SUMIF公式點樣靠SUMPRODUCT簡化呢?
=SUMIF($A$2:$A$16,F3,$B$2:$B$16)+SUMIF($A$2:$A$16,F3,$C$2:$C$16)+SUMIF($A$2:$A$16,F3,$D$2:$D$16)
一齊睇睇教學片詳細講解啦!