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

[µo°Ý] SUMPRODUCT§ï¼g¦¨SUMIFS¤è¦¡

[µo°Ý] SUMPRODUCT§ï¼g¦¨SUMIFS¤è¦¡

¤j®a¦n¡G
­ì¨Ï¥ÎSUMPRODUCT¡A¦ýÀHµÛ¼Æ¾Ú¼Æ¶q¶V¨Ó¶V¤j¡AEXCEL¶]±o«ÜºC¡Agoogleµo²{»¡SUMIFS·|¤ñ¸û§Ö¡A©Ò¥H·Q§ï¼g¦¨SUMIFS¡A¦ý¤@ª½µLªk¦¨¥\¡C
¥Î²³æ½d¨Ò»¡©ú¦pªþ¥ó¡A­ì©l¸ê®Æªºcolumn¦³¥]§t¦~«×¡A§Ú·Q¾ã²z¦¨ªº®æ¦¡¡A¬O·|®Ú¾Ú·Q­nªº¦~«×¥h§ì¨ú(Àx¦s®æM1 N1§Ú¥i¥HÀH®É§ï¦¨§Ú·Q­nªº¦~«×)¡A
©Ò¥H¥ÎSUMPRODUCT¥i¥H¥Îcolumnªº¦~«×·í¦¨±ø¥ó¡A¦ýSUMIFS¦n¹³¤£¯à§âcolumnªº¦~«×·í¦¨±ø¥ó¡C
·Q½Ð±Ð¦U¦ì¤j®v¡A¦³¿ìªk¥ÎSUMIFS¨Ó¹F¦¨§Úªº»Ý¨D¶Ü¡H
¦b¦¹¥ýÁ¹L!!
°ÝÃD.zip (7.39 KB)

[i=s] ¥»©«³Ì«á¥Ñ zz5151353 ©ó 2019-12-31 10:39 ½s¿è [/i]

M2

    =SUMIFS(OFFSET($C:$C,,MATCH(M$1,$C$1:$H$1,)-1,,),$A:$A,$K2,$B:$B,$L2)
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¥»©«³Ì«á¥Ñ handmuch ©ó 2019-10-23 09:58 ½s¿è

SUMIFS(OFFSET($B$1,1,MATCH(M$1,$C$1:$H$1,0),7,1),$A$2:$A$8,$K2,$B$2:$B$8,$L2)
http://expresmile.teachable.com

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD