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

Ãö©ócountif³]©w2­Ó±ø¥ó

Ãö©ócountif³]©w2­Ó±ø¥ó

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2013-3-27 21:53): ½Ð¤W¶ÇÀÉ®×

½Ð°Ý¤@¤U

Countif ¥i¥H¥[Á`²Å¦X2­Ó±ø¥ó¶Ü?

§Ú¬O·s¤â

½Ð¦h¦h«ü±Ð  ÁÂÁÂ! :L

¬O³o¼Ë¶Ü?
  1. =COUNTIF(A1:A65536,"¥i¤f¥i¼Ö")+COUNTIF(A1:A65536,"³·ºÑ")
½Æ»s¥N½X

TOP

office 2007ªºª©¥»¡A¥i¥Î countifs­pºâ²Å¦X¨â­Ó¥H¤Wªº±ø¥ó¥[Á`¡A¤U¦Cºô§}¦³½d¨Ò¥i°Ñ¦Ò
http://office.microsoft.com/zh-tw/excel-help/HA102753238.aspx?CTT=1

TOP

¬O³o¼Ë¶Ü?
01.=COUNTIF(A1:A65536,"¥i¤f¥i¼Ö")+COUNTIF(A1:A65536,"³·ºÑ")


=SUM(COUNTIF(A1:A1000,{"¥i¤f¥i¼Ö","³·ºÑ"}))

TOP

¥H¸Ñ¨M¤F COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]¡K)

·PÁ¦U¦ì ^^

TOP

½Ð°Ý°²³]²Å¦X2­Ó±ø¥ó«á,¦Ó³o2­Ó±ø¥ó«áªº©Ò¦³¸ê®Æ¥þ³¡±a¥X­n¦p¦ó¼g?ÁÂÁÂ!!

TOP

        ÀR«ä¦Û¦b : ¤Ñ¤W³Ì¬ü¬O¬P¬P¡A¤H¥Í³Ì¬ü¬O·Å±¡¡C
ªð¦^¦Cªí ¤W¤@¥DÃD