Cch tnh s? l?n xu?t hi?n c?a s? ho?c vn b?n trong m?t d?i trong Excel

D?ch tiu ? D?ch tiu ?
ID c?a bi: 214153 - Xem s?n ph?m m bi ny p d?ng vo.
Bung t?t c? | Thu g?n t?t c?

? Trang ny

Tm t?t

Bi vi?t ny gi?i thch cch b?n c th? s? d?ng cc hm trong b?ng tnh trong Microsoft Excel dnh cho Mac ? ?m s? l?n xu?t hi?n c?a m?t s? ho?c chu?i vn b?n c? th? trong m?t d?i trn b?ng tnh. Ph?n "Thng tin khc" trong bi vi?t ny ch?a cng th?c m?u m b?n c th? s? d?ng ? th?c hi?n vi?c ny.

Thng tin thm

Trong b?n mu?n k?t qu? xu?t hi?n, nh?p cng th?c thch h?p t? cc v d? sau y.

Cch ?m s? l?n xu?t hi?n c?a m?t s?

S? d?ng cng th?c sau
=SUM(IF(range=number,1,0))
trong range l d?i m b?n mu?n t?m ki?m number l s? m b?n mu?n ?m.

CHU Y: Cng th?c ny ph?i ?c nh?p d?i d?ng cng th?c m?ng. ? nh?p cng th?c m?ng, nh?n CTRL+SHIFT+ENTER.

Cch tnh s? l?n xu?t hi?n c?a Chu?i Vn b?n

Phng php 1

S? d?ng cng th?c sau
=SUM(IF(range="text",1,0))
trong range l d?i m b?n mu?n t?m ki?m v text l vn b?n m b?n mu?n t?m (vn b?n ph?i n?m trong d?u ngo?c kp).

CHU Y: Cng th?c trn ph?i ?c nh?p d?i d?ng cng th?c m?ng. ? nh?p cng th?c m?ng, nh?n CTRL+SHIFT+ENTER.

Phng phap 2

S? d?ng hm COUNTIF() ? tnh s? l?n xu?t hi?n c?a chu?i vn b?n. V d?: s? d?ng cng th?c
=COUNTIF(range,"text")
trong range l d?i m b?n nh gi v text l chu?i vn b?n b?n mu?n tnh s? l?n xu?t hi?n (xin lu ? r?ng text ph?i n?m trong d?u ngo?c kp).

CHU Y: Cng th?c ny ph?i ?c nh?p d?i d?ng cng th?c m?ng. ? nh?p cng th?c m?ng, nh?n CTRL+SHIFT+ENTER.

C th? s? d?ng k? t? ?i di?n trong hm COUNTIF.

K? t? d?u hoa th? (*) ?i di?n cho nhi?u hn m?t k? t?. V d?: ? tnh t?t c? cc trong d?i a1:a10 ch?a "x," b?n c th? s? d?ng cng th?c sau y:
=COUNTIF(a1:a10,"*x*")
K? t? d?u ch?m h?i (?) c?ng c th? ?c s? d?ng ? ?i di?n cho m?t k? t? ?i di?n -- v d?: ? tnh t?t c? cc trong d?i c k? t? th? hai l ch?, ch?ng h?n nh "ax" ho?c "bx".
=COUNTIF(a1:a10,"?x*")

Thu?c tnh

ID c?a bi: 214153 - L?n xem xt sau cng: 02 Thang Mi Hai 2013 - Xem xt l?i: 4.0
p d?ng
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel X for Mac
  • Microsoft Excel 2001 for Mac
  • Microsoft Excel 98 for Macintosh
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Office Excel 2003
  • Microsoft Excel 2010
  • Microsoft Office Excel 2007
T? kha:
dftsdahomeportal kbhowto KB214153

Cung cp Phan hi

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com