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

[µo°Ý] Ãö©óSUMPRODUCT¨ç¼Æ...

¦^´_ 3# andy8426

¥À¿Ë¸`¤Ó¦£¤F¡A«e­±«Øij2¨S¦³®É¶¡¼g¡A¥ý¼g¤@­Ó»²§UÄæ§ïµ½¤èªk
test1 SUMPRODUCT¤ÓºC.rar (17.77 KB)

4­Ó²³æ¤½¦¡¡A¦ý¤ñ­ì¤½¦¡§Ö¦h¤F¡AÁöµMCOUNTIF¨ç¼Æ«ÜºC¡A§Ú¤£¤Ó³ßÅw¨Ï¥Î¥L¡A¦ý¤j®a³£«Ü¼ôÁÙ¬O¥Î§a

Sheet3 L1 =COUNTA(Sheet4!B:B)
Sheet3 J1 =IF(C2="",J1,C2)
Sheet3 H2 =COUNTIF(OFFSET(Sheet4!E$1,,,L$1),J2&"__"&F2)
Sheet4 E1 =B1&"__"&C1
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 11# ML089

·PÁ«ü¾É~  

¥¿±`Sheet4¸ê®Æ³q±`³£¬O¤j©ó10¸Uµ§...  ©Ò¥H¤~·|¨Ï¥ÎB:B   C:C
¦ÓSheet3·|¦³3808­Ó­pºâ.
¨Ï¥ÎSUMPRODUCT·|¶]«Ü¤[.

¥Ø«e¨Ï¥ÎªO¤j±Ð¾ÇªºVBA­×§ï«á,¤w§¹¦¨³øªí.
M¥S´£¨Ñªºªþ¥ó,¥Ø«e¤p§ÌÅv­­¤£¨¬µLªk¤U¸ü,4­Ó²³æªº¤½¦¡§Ú·|¦b¹Á¸Õ.^^

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD