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

[µo°Ý] ¥[Á`ªº¤½¦¡

¦^´_ 9# PJChen

=SUMIF($C$3:$Z$3,AA$3,$C4)  ©M =SUMIF($C$3:$Z$3,AA$3,$C4:$Z4)  ªð¦^ªºµ²ªG³£¬O¤@¼Ë

=SUMIF($C$3:$Z$3,AA$3,$C4) ¬O²¼gªk

¦P¼Ëªº²z¥Ñ :

=SUMIF($C$3:$Z$3,AA$3,$D4) µ¥©ó =SUMIF($C$3:$Z$3,AA$3,$D4:$AA4)

............................

TOP

¦^´_ 10# ANGELA

¤j¤j,

½Ð°Ý: ¤°»ò±¡§Î¤U¬O¥i¥H¬Ù²¤¨Ï¥Îªº?
   =SUMIF($C$3:$Z$3,AA$3,$C4)
       ­pºâ³æ¤¸®æ¡A¥u­n«ü¥X°_©lªº³æ¤¸®æ§Yº¡¨¬SUMIFªº±ø¥ó¡A¤£¤@©w­n«ü¥Xµ²§ôªº³æ¤¸®æ¡C
       ¤½¦¡¼ôªº¤H±`·|¬Ù¥h¤@¨Ç°Ñ¼Æ¡A¦p,0  ,""·|¥u¼g,

TOP

excel¨ç¼Æ黙»{ªº´N¥i¬Ù²¤,¤£¹L¤£¼ôÁÙ¬O³W¯xÂI¸û«OÀI
=SUMIF($C$3:$Z$3,AA$3,$C4)
»P
=SUMIF($C$3:$Z$3,AA$3,$C4:Z4)
µ²ªG¬O¤@¼Ëªº
=SUBSTITUTE(A3,"ab",) =>   =SUBSTITUTE(A3,"ab","")
¨ä¥¦ÁÙ¦³«Ü¦hºCºC¤F¸Ñ§a

TOP

¦^´_ 13# ANGELA

¬Ý¨Ó¤£¤Gªkªù´N¬O­n¦h¼ô±x! TKS.

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD