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

[µo°Ý] ¦p¦ó±N ­p¼Æ«á¥[Åv¦A¥[Á` ¼g¦¨¤@­Ó¨ç¼Æ¡H

[µo°Ý] ¦p¦ó±N ­p¼Æ«á¥[Åv¦A¥[Á` ¼g¦¨¤@­Ó¨ç¼Æ¡H

¥»©«³Ì«á¥Ñ jsleee ©ó 2019-8-13 13:38 ½s¿è

±z¦n¡A½Ð±Ð¦U¦ì¥ý¶i¤@­Ó°ÝÃD¡A§Ú¦³¤@¨Ç­ì©l¼Æ¾Ú¸ê®Æ¡A
­n¥ý­pºâ­Ó¼Æ»P½d³ò¤ºªºÁ`©M­È¡AµM«á­¼¥H Åv­«¡A³Ì«á¦A¥[Á`
¤£ª¾¹D³o­Ó³Ì«á¥[Á`³o­Ó¼Æ­È¯à§_¥Î¤@­Ó½Æ¦X¨ç¼Æª½±µºâ¥X¨Ó¡H
¨Ò¦p¤U¹Ï¤¤ªº¬õ¦â¼Æ­È 64 & 185¡A§Æ±æ¥i¥Hª½±µ±q ¶À¦â»Pºñ¦â°Ï¶ôªº­ì©l¸ê®Æª½±µ¥Î¤@­Ó½Æ¦X¨ç¼Æ­pºâ¥X¨Ó

­p¼Æ¥[Åv«á¥[Á`.jpg (35.59 KB)

­p¼Æ¥[Åv«á¥[Á`.jpg

=SUMPRODUCT((A3:C9>0)*H3:H9)
=SUMPRODUCT(A3:C9*H3:H9)

TOP

¦^´_ 2# ­ã´£³¡ªL

·PÁ ­ã´£³¡ªL ¥ý¶iªº«üÂI

TOP

        ÀR«ä¦Û¦b : ¹ï¤÷¥À­nª¾®¦¡A·P®¦¡B³ø®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD