ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] SUMPRODUCT ¤À§O

[µo°Ý] SUMPRODUCT ¤À§O

SUMPRODUCT¤ÀªR.rar (8.33 KB) *·Q¥ÎSUMPRODUCT¨ç¼Æ²Î­p¨C­ÓDEPT¨ú±oA, ©ÎB©ÎCªº¤H¼Æ. ±ø¥ó¬O¦pGrade2¦³¨ú¼Æ­È, ¥u­pGrade2; ¦pGrade2¨S¦³¨ú¼Æ­È, ¤~­pGrade1;
½Ð½ç±Ð!

¦^´_ 1# missbb

=SUM(($B$6:$B$9=B$14)*(IF($D$6:$D$9="",$C$6:$C$9,$D$6:$D$9)=$A15))
°}¦C¤½¦¡¡ACTRL+SHIFT+ENTER»ô«ö¿é¤J¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 2# ML089

·PÁ±z!:)

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD