ªð¦^¦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)

c2:c7=SUMIFS(¶i³f!$C:$C,¶i³f!$A:$A,B2,¶i³f!$B:$B,$A2)
c2:c7 ½Æ»s¨ì¦U°Ï
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522


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

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD