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

»s§@µû¤Àªíªº°ÝÃD¡I

»s§@µû¤Àªíªº°ÝÃD¡I

µû¤À.rar (6.42 KB)
¤p§Ì¦³¤@­Óµû¤Àªí¤½¦¡  {=SUM(COUNTA(OFFSET($B$7,,COLUMN(A1),,))*OFFSET($B$5,,COLUMN(A1),,))}
¤@ª½µLªk¥[Á`¡A¤£ª¾¹D¬O§_¦³¤H¥i¥HÀ°¦£¸Ñ¤@¤U¡C·PÁÂ
­É¿ú¤£ÁÙ¡A¤~¬O¤ý¹D

{=SUM(COUNTA(OFFSET($C$7,,COLUMN(A1),,5))*OFFSET($C$5,,COLUMN(A1),,5))}
³o¼Ë¤l¤]¤£¦æ...............................
­É¿ú¤£ÁÙ¡A¤~¬O¤ý¹D

TOP

{=SUM(COUNTA(OFFSET($C$7,,COLUMN(A1),,5))*OFFSET($C$5,,COLUMN(A1),,5))}
³o¼Ë¤l¤]¤£¦æ...............................
­É¿ú¤£ÁÙ¡A¤~¬O¤ý¹D

TOP

¥»©«³Ì«á¥Ñ ANGELA ©ó 2011-9-23 09:40 ½s¿è

{=SUM(IF(C7:G7<>"",1,0)*$C$5:$G$5)}   <--
sorry, §Ú­è¸£µ¬¡iª¦§b¡j¡A·Q±o¤Ó¹L¤õ¤F¡A³o¼Ë´N¸Ñ¥X¨Ó¤F.............................³oÃDªº¤À¼ÆÀ°¦£¦©±¼¦n¤F¡C
­É¿ú¤£ÁÙ¡A¤~¬O¤ý¹D

TOP

=SUMPRODUCT((C7:G7<>"")*$C$5:$G$5)

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD