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

[µo°Ý] COUNTIFS²Î­p½Æ¼Æ±ø¥ó°ÝÃD

[µo°Ý] COUNTIFS²Î­p½Æ¼Æ±ø¥ó°ÝÃD



·Q½Ð±Ð¤@¤U¬°¦óC7¤½¦¡²Î­pµ²ªG¦³°ÝÃD¡H¬O§_COUNTIFSµLªk²Î­p½Æ¼Æ±ø¥ó¡H
ÁöµM¤p©fª¾¹D¥t¤@­ÓSUMPRODUCT¤½¦¡¥i¸Ñ¨M½Æ¼Æ±ø¥ó²Î­p°ÝÃD¡A¦ý¤½¥q¸ê®ÆÀɬù¦³¢³¸Uµ§¸ê®Æ®É¡Aµo²{¨Ï¥ÎSUMPRODUCT¹Bºâ³t«×¸ûºC¤]¸û¤[
©Ò¥H¤~¥´ºâ§ï¥ÎCOUNTIFS¤½¦¡¡ã¡ã¡ã¡ã

¨D¸Ñ¡H¡H¡H

´ú¸Õ.rar (24.94 KB)
*¦v¤k¤@ªTµL»~*

¦^´_ 11# hcm19522

«D±`·PÁ³áh¤j~~~~~~



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

­ã¤j¤]«D±`·PÁ±zªº¼ö¤ß¦^ÂÐ
*¦v¤k¤@ªTµL»~*

TOP

¥|¸U¦hµ§¡A³Ì¦nÁÙ¬O¥Î»²§U¤½¦¡¡A¥H§K¥dÀÉ¡I¡I
¥t¤@°Ñ¦Ò¡G
=N(COUNT(FIND({"´«³f","DOA"},A2))*COUNT(FIND({"µLªk¶}¾÷","½Ý½u","¾î½u"},B2))*COUNT(FIND({"ªù¥«","ºô¸ô"},C2))>0)

TOP

¦^´_ 9# msmplay

¦³¿³½ì¨ì¦¹«ü±Ð    2000¦h½g
http://blog.xuite.net/hcm19522/twblog?&p=2

TOP

¦^´_ 7# KCC

­ì¨Ó¦p¦¹¤X~~~~~¤p©f¤µ¤Ñ¤S¦h¤W¤F¤@½Ò¡A¤]«D±`·PÁ±z³áK¤j!!!!
*¦v¤k¤@ªTµL»~*

TOP

¦^´_ 6# hcm19522

h¤j~~±z´£¨Ñªº¤èªk§Ú¨ì¤½¥q¦A´ú¸Õ¬Ý¬Ý¡A«D±`·PÁ³á!!
*¦v¤k¤@ªTµL»~*

TOP

©êºp¡A­èµo²{¼g¿ù¤F

¦pªG¬O³r¸¹¡A{"´«³f","*DOA*"} {"*µLªk¶}¾÷*","*½Ý½u*","*¾î½u*"} ¨â°}¦C³£¬O¤ô¥­
­ì¤å¤w¶W¹L­×§ï®É­­¡A¦b³o¸Ì§ó¥¿

TOP

¥»©«³Ì«á¥Ñ KCC ©ó 2016-6-4 22:03 ½s¿è

¦^´_ 4# msmplay


    ³oºâ¬Oexcel°}¦C¹Bºâªº¯S©Ê§a¡A§Úªº²z¸Ñ¤j­P¦p¤U
   {1,1} ¬O¤ô¥­°}¦C {1;1}¬O««ª½°}¦C ¬Û­¼·|ÅÜ {1,1;1,1},SUM¤§«á¬O4
   ¦pªG³£¬O¤ô¥­°}¦C {1,1}*{1,1}={1,1}, sum¤§«á¬°2
   
   ¥H³oÆ[©ÀÃþ±À©p©Ò­nºâªº
   ¦pªG¬O³r¸¹¡A{"´«³f";"*DOA*"} {"*µLªk¶}¾÷*","*½Ý½u*","*¾î½u*"} ¨â°}¦C³£¬O¤ô¥­¡A·|Åܦ¨¨D  ("´«³f","*µLªk¶}¾÷*","ªù¥«"), ("*DOA*","*½Ý½u*","ªù¥«") ,("" ,"*¾î½u*","ªù¥«") ¤T²Õ±ø¥ó
   ´«¦¨ ¤À¸¹¡A´N·|Åܦ¨ ¤@­Ó 2*3ªº°}¦C(¤Ï¤§´NÅܦ¨3*2°}¦C) =>  ("´«³f","*µLªk¶}¾÷*","ªù¥«") ("*DOA*","*µLªk¶}¾÷*","ªù¥«), ....................¦@¤»²Õ±ø¥ó

   ¦Ü©ó©pªº²Ä¤G­Ó°ÝÃD¡A¦pªG¦A§â²Ä¤Tºû«×(ªù¥«¡Bºô¸ô...)ÂX¥R¡A¹ï¦hºû«×°Ñ·Ó¤§Ãþªº±Í¤H¤@ª½¨S·d±o«Ü²M·¡¡A¥Ø«eµLªkÀ°±o¤W¦£¡A©çÁ¡C

   ¥t¥~¡Ah¥S¥Îªºmmult¡A¥Îªº¦nªº¸Ü³t«×·|§Ö«Ü¦h¡A¤]¥i¦h°Ñ¦Ò¡C

TOP

¦^´_ 5# msmplay
§Ú¤]µo²{ "," »P ";" ¤£¸Ñ¨ä·N ¦ý¤GÃä "," »P ";" ¹ï½Õ ¥ç¥i¦æ ÀR«Ý KCC¤j½ç±Ð

TOP

¦^´_ 3# hcm19522

h¤j~~~¤]«D±`·PÁ±zªº¼ö¤ßÀ°¦£­ò!!
*¦v¤k¤@ªTµL»~*

TOP

        ÀR«ä¦Û¦b : ·R¤£¬O­n¨D¹ï¤è¡A¦Ó¬O­n¥Ñ¦Û¨­ªº¥I¥X¡C
ªð¦^¦Cªí ¤W¤@¥DÃD