Áö½ÄÀο¡ ¿©·¯°¡Áö ã¾Æº¸´Ù µµÀúÈ÷ ¾ÈµÇ¼ Áú¹®µå¸³´Ï´Ù
A¿¿¡ 1ºÎÅÍ 8±îÁö µÚÁ×¹ÚÁ× ¹è¿
B¿¿¡ µ¿Çع°°ú¹éµÎ»êÀ̸¶¸£°í´âµµ·Ï °°Àº ¹®ÀåÀÌ ÀÖ´Ù¸é
A¿ÀÇ 1 ÀÌ¸é¼ B¿¿¡ ¹®ÀåÁß "¹éµÎ»ê"À̶õ ´Ü¾î¸¦ Æ÷ÇÔÇÑ ¼¿ÀÇ °¹¼ö¸¦ Ä«¿îÅÍ ÇÏ·ÁÇÕ´Ï´Ù
ÆùÀÌ¶ó ¼³¸íÀÌ ºÎ½ÇÇÏÁö¸¸ ´É·ÂÀںР°è½Ã¸é ºÎŹµå¸³´Ï´Ù
È¥ÀÚ ³×À̹ö ³¢°í a¿ÀÇ Æ¯Á¤¼ýÀÚ b¿ÀÇ ´Ü¾î ã±â´Â Çϰڴµ¥
¹®ÀåÁß¿¡ ƯÁ¤´Ü¾î ã±â°¡ ¾È´ë³»¿ä ¤Ð
Countif·Î "*¹éµÎ»ê*"·Î´Â µÇ´Âµ¥ ¸»ÀÌÁÒ ¤Ð
ºÎŹµå¸³´Ï´Ù^^ | |
|
countifs °¡ Áߺ¹ Á¶°ÇÀ̶õ°É µ¡±Û ´ö¿¡ ¾Ë¾Æ°¡³»¿ä ¤¾¤¾
´Ù¸¥ Á¶°Çµéµµ countifs·Î ÇÒ°É ±¦È÷ sumproduct·Î ÇÑ°Å °°Àº ¤Ð¤Ð