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

[µo°Ý] ½Ð°Ý¦p¦ó¨Ï¥ÎSUMIFS¦h±ø¥ó¥[Á`°ÝÃD?

[µo°Ý] ½Ð°Ý¦p¦ó¨Ï¥ÎSUMIFS¦h±ø¥ó¥[Á`°ÝÃD?

§Ú­n¦p¦ó­×§ïSUMIFS¨ç¼Æ¡A¤~¥i¥H±o¨ì§Ú¬õ¦â®Ø®Ø¤º¡A¥¿½T·Q­nªº¼Æ­È  ÁÂÁÂ!!

¬¡­¶Ã¯4.rar (8.29 KB)

¦^´_ 2# hcm19522


    °ÂÁÂ!!§Aªº«ü¾É

TOP

c2:c7=SUMIFS(¶i³f!$C:$C,¶i³f!$A:$A,B2,¶i³f!$B:$B,$A2)
c2:c7 ½Æ»s¨ì¦U°Ï
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD