=COUNTIF(A2:A5,"apples") Number of cells with apples in the first column above (2)
=COUNTIF(A2:A5,A4) Number of cells with peaches in the first column above (1)
=COUNTIF(A2:A5,A3)+COUNTIF(A2:A5,A2) Number of cells with oranges or apples in the first column above (3)
=COUNTIF(B2:B5,">55") Number of cells with a value greater than 55 in the second column above (2)
=COUNTIF(B2:B5,"<>"&B4) Number of cells with a value not equal to 75 in the second column above (2)
=COUNTIF(B2:B5,">=32")-COUNTIF(B2:B5,">85")
| Formula | Description (result) |
| =COUNTIF(A2:A7,"*es") | Number of cells ending with the letters "es" in the first column above (4) |
| =COUNTIF(A2:A7,"?????es") | Number of cells ending with the letters "les" and having exactly 7 letters in the first column above (2) |
| =COUNTIF(A2:A7,"*") | Number of cells containing text in the first column above (4) |
| =COUNTIF(A2:A7,"<>"&"*") | Number of cells not containing text in the first column above (2) |
| =COUNTIF(B2:B7,"No") / ROWS(B2:B7) | The average number of No votes including blank cells in the second column above formatted as a percentage with no decimal places (33%) |
| =COUNTIF(B2:B7,"Yes") / (ROWS(B2:B7) -COUNTIF(B2:B7, "<>"&"*")) | The average number of Yes votes excluding blank cells in the second column above formatted as a percentage with no decimal places (50%) |
'연구하는 인생 > ♣COMPUTER' 카테고리의 다른 글
| Java 기술에 대한 자세한 내용 (0) | 2011.06.24 |
|---|---|
| QR code- Wikipedia, the free encyclopedia (0) | 2011.06.14 |
| MS Office, Internet Explorer __ 特殊文字 사용 (0) | 2011.04.12 |
| CHKDSK/F D: (0) | 2011.03.30 |
| Active X (0) | 2011.03.25 |