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

[µo°Ý] ¦p¦ó±N¤£¦P¤À¼Æ°Ï¶¡²Î­p¼Æ¶q¤ÎÁ`©M

[µo°Ý] ¦p¦ó±N¤£¦P¤À¼Æ°Ï¶¡²Î­p¼Æ¶q¤ÎÁ`©M

¥»©«³Ì«á¥Ñ jackson7015 ©ó 2017-11-10 16:32 ½s¿è

°²³]
[A]¦³¤£¦Pªº¤À¼Æ¼Æ­È¡A[B]¦³¤£¦Pªº¼Æ¶q
·Q²Î­p[A:B]ªº¤£¦P¤À¼Æ°Ï¶¡ªº¤À¼Æ¼Æ¶q¤Î°Ï¶¡¤À¼ÆÁ`©M
°Ï¶¡ªº³¡¤À¦³
60¥H¤U
60-100
101-200
201-300
301-400
401-500
501-600
601-700
701-800
801-900
901-1000
1001¥H¤W


¦Û¤v¨Ï¥Î SUMPRODUCT ²Î­pªº®É­Ô¡A¥u·|²Î­p¥X¤À¼Æ°Ï¶¡ªº"­Ó¼Æ"¡A¤£·|²Î­p°Ï¶¡Á`¼Æ
©Ò¥H·Q½Ð±Ð¯¸¤Wªº¤j¤jÀ°¦£¨ó§U¡A·PÁÂ!!

¤À¼Æ°Ï¶¡²Î­p¼Æ¶q¤ÎÁ`©M.zip (25.68 KB)

¦^´_ 1# jackson7015

°Ñ¦Ò¬Ý¬Ý
­Ó¼Æ
F2¶ñ¤J
  1. =SUMPRODUCT(--(B:B<60),C:C)
½Æ»s¥N½X
¦X­p
G2¶ñ¤J
  1. =SUMPRODUCT(--(B:B<60),B:B,C:C)
½Æ»s¥N½X
³Æµù¡GSUMPRODUCT¨ç¼Æ·|§â¤å¦rµø¬°0¡A¦pµ²ªG¬°0½ÐÀˬd¨Ó·½½d³ò¤º¬O§_¬°¤å¦r

TOP

¦^´_ 1# jackson7015


   
2017-11-10_183000.png
2017-11-10 18:32

   
2017-11-10_183125.png
2017-11-10 18:32

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¤Hªº²´·úªø¦b«e­±¡A¥u¬Ý¨ì§O¤Hªº¯ÊÂI¡Aµ·²@¬Ý¤£¨ì¦Û¤vªº¯ÊÂI¡C
ªð¦^¦Cªí ¤W¤@¥DÃD