[Åë°è ÇÔ¼ö] COUNT / COUNTA
¡Ü COUNT/COUNTA
COUNT : ÁöÁ¤µÈ ¼¿ ¹üÀ§ ¶Ç´Â ¼¿°ª¿¡¼ °ø¹éÀ» Á¦¿ÜÇÑ ¼ýÀÚ, ³¯Â¥°¡ ÀÖ´Â
¼¿ÀÇ °³¼ö¸¦ ±¸ÇÕ´Ï´Ù.
COUNTA : ÁöÁ¤µÈ ¼¿ ¹üÀ§ ¶Ç´Â ¼¿°ª¿¡¼ Àμö °ø¹éÀ» Á¦¿ÜÇÑ ¸ðµç ¼¿ÀÇ °³¼ö¸¦ ±¸ÇÕ´Ï´Ù.
¢º Çü½Ä
COUNT(value1,value2, ...)
value,value2,... : ¼¿ ¹üÀ§ ¶Ç´Â ¼¿À» ÁöÁ¤ÇÕ´Ï´Ù.(ÃÖ´ë 30°³ ÂüÁ¶¿µ¿ª)
[»ç¿ë ¿¹]
COUNT ÇÔ¼ö¼ö½Ä : =COUNT(B2:B6)
COUNTA ÇÔ¼ö¼ö½Ä : =COUNTA(B2:B6)
¼³¸í : COUNTÇÔ¼ö´Â ¡°°á¼®¡±À̶ó´Â ÅؽºÆ®¸¦ Á¦¿ÜÇÑ ¼ýÀÚ¿¡ ´ëÇؼ °³¼ö¸¦ ±¸Çϸç,
COUNTAÇÔ¼ö´Â ¡°°á¼®¡±À̶ó´Â ÅؽºÆ®¸¦ Æ÷ÇÔÇÑ ¸ðµç ¼¿¿¡ ´ëÇؼ °³¼ö¸¦ ±¸ÇÕ´Ï´Ù.
ÀÌÀü±Û | [Åë°è ÇÔ¼ö] AVERAGE |
---|---|
´ÙÀ½±Û | [ÅؽºÆ® ÇÔ¼ö] REPLACE |