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

®æ¦¡¤Æ±ø¥ó¦p¦ó¥ý¤º®e«á¦A½T»{¼Æ­È½d³ò

®æ¦¡¤Æ±ø¥ó¦p¦ó¥ý¤º®e«á¦A½T»{¼Æ­È½d³ò

¦pªþ¥ó
B¡BCÄæ³£¬O¤H¤u¿é¤J
¨C­Ó¶µ¥Ø¦³¤£¦Pªº±ø¥ó³]©w
·Q¨Ï¥Î®æ¦¡¤Æ±ø¥óÅýEXCEL¦Û¦æ§PÂ_¨ä¿é¤Jµ²ªG¬O§_¦³²§±`

ex.
B3¿é¤JA¡AC3¿é¤J30¡AAªº¤W­­¬O80¡A30¤¶©ó³o­Ó½d³ò¡A²Å¦X³W®æµLÅã¥Ü©³¦â
B4¿é¤JB¡AC4¿é¤J75¡AB¤¶©ó40~70¡A75©ó½d³ò¥~¡A¤£²Å¦X³W®æÅã¥Ü©³¦â
¥D­n¬O¤H­û¿é¤J«á¥i¥H§Ö³t±oª¾¬O§_²Å¦X³W½d¡A¤£»Ý¤H­û°O¾Ð¦UºØ¶µ¥Øªº³W«h

Book1.zip (1.61 KB)

¬Ý¨ìµª®×...«éµM¤j®©
©ú©ú¦Û¤v«Ü±`¨Ï¥Îsumproduct¨Ó°µsumifs¡Bcountifsªº¥\¯à
¸£³U¤Ó¦ºªO¤F.....

TOP

¦^´_ 4# vvcvc

Book1.zip (8.27 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¬ðµM·Q¨ì + À³¸Ó¬OOR¤~¹ï
(C3<x)+(C3>y)
§ï¦¨OR((C3<x),(C3>y))±o¨ìªºµ²ªG´N¬Û¦P¤F

TOP

¦pªG¼W¥[¤@­Ó¤ñ¹ïªº±ø¥ó¡A¸Ó«ç»ò±ø§ï?
¦pªþ¥óSheet2
Book1.zip (4.2 KB)

TOP

ÁÂÁ¦^ÂСA¤w±o¨ì»Ý­nªºµ²ªG

¦³­ÓºÃ°Ý¡A¥i¥HÄÀºÃ
(C3<x)+(C3>y)
½Ð°Ý¦b¤½¦¡¤¤ªº + ¬O and ªº·N«ä¶Ü
¬°¤°»ò§Ú§ï¦¨AND((C3<x),(C3>y))«o±o¤£¨ì¬Û¦Pªºµ²ªG?

TOP

¦^´_ 1# vvcvc


    Book1.zip (3.89 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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