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

[µo°Ý] ·~ÁZ¹ô§O¬d§ä

[µo°Ý] ·~ÁZ¹ô§O¬d§ä

¤½¥qªº·~ÁZ²Î­pªí«È¤á±Æ¦C¦³©T©wªº¶¶§Ç¡A©Ò¥H¤£¤è«K¥Î¼Ï¯Ã¡]ÁÙ¬O¥i¥H¡H¡^
©Ò¥H¥[¤F»²§UÄæ¥h­pºâ¦U«È¤á¨C¤ëªº·~ÁZ¡C

¦p¤W¹Ï¡A¢Ð°Ï¬°¨C¤Ñªº¾P³fª÷ÃB¡A¢Ñ¬°¨C¤ëªºª÷ÃB¡]¶·´«ºâ¦¨¥x¹ô¡^
¦b´«ºâ¦¨¥x¹ô¤è­±¡A·Q¤£¥X­n«ç»ò±a¶i¤½¦¡¤º¡A¦p¤U¹Ï¡A
½Ð°Ý¤½¦¡«á­±¦p¦ó¥[¤W±a¤J¥x¹ôªº¤½¦¡¡H


ÁÂÁ¡C
·~ÁZ.zip (8.17 KB)

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

=SUMPRODUCT(($H$3:$H$21=$N3)*($F$3:$F$21=O$2)*SUMIF($B$3:$D$3,$I$3:$I$21,INDEX($B:$D,O$2+3,)),$J$3:$J$21)

¦P¤@«È¤á¦P®É¨Ï¥Î¤£¦P¹ô§O¤]¥i¥H~~

TOP

¦^´_ 2# hcm19522
¦^´_ 3# ­ã´£³¡ªL
ÁÂÁ¨â¦ì

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD