¿¢¼¿ ÇÏ¸é¼ ±ô¦ ³î¶ú³×¿ä ;;
- ÀÛ¼ºÀÏ
- 09-01-13 00:47
- ±Û¾´ÀÌ
- Player
- IP
- 221.¢½.¢½.209
- ±Û¾´ÀÌÀÇ ´Ù¸¥ °Ô½Ã¹° º¸±â
- ̵̧
- 0
- Á¶È¸
- 538
Á¤¸» À߸ø ¾Ë°í »ì¾Æ¿Ô´Âµ¥ ÇöÀçµµ ´äÀ» ¸ð¸¥´Ù´Â°Å ¤Ð
±×·³ º»·Ð¿¡ °¡¼ ¤Ì
A1=1 B1=2 A2=3 B2=4 ¶ó´Â ¼¿ÀÌ ÀÖ½À´Ï´Ù
=SUM(A1:B1) ´ä : 3
=SUM(A2:B2) ´ä : 7 ÀÌ Á¤´äÀÌÁö¿ä
±Ùµ¥ =SUM(A1:B1*A2:B2)¸¦ ÇÏ°Ô µÇ¸é
¿Ö ´äÀÌ 3ÀÌ µÇ´ÂÁö ÀÌÇØ°¡ ¾È°¡³×¿ä ¤Ð
3°öÇϱâ 7 ¾Æ´Ñ°¡¿ä?
¿ì¿¬È÷ ¹è¿¼ö½Ä °øºÎÇÏ´Ù°¡ ÀÌÇØ°¡ ¾ÈµÇ¼ °£´ÜÇÑ°É·Î ¸·
À̸®Àú¸® ÇÏ´Ù°¡ ¼ø°£ ÀÌ°Å ¹¹Áö?
Ʋ¸²¾øÀÌ °£´ÜÇÑ °Å ÀÏÅÙµ¥ ÀÌ°Å ¾î¶»°Ô ÀÌÇØ ÇØ¾ß Çϴ°ÅÁÒ?
¼ö½Ä Á» Ç®¾îÁÖ¼¼¿ä ¤Ð ÁøÂ¥ Ãæ°ÝÀ̳׿ä
±×¸®°í ÇÑ°¡Áö¸¸ ´õ¿ä ¤Ð
=SUM(IF(B10:B35=P10,1,0))&"°Ç"
{=SUM(IF(B10:B35=P10,1,0))&"°Ç"}
ÀÌ 2°³ÀÇ Â÷ÀÌ°¡ ¹¹ÁÒ ¤Ð
ù¹ø°´Â B10:B35ÀÇ ¹üÀ§¿¡¼ P=10°ú °°Àº °ªÀÏ °æ¿ì 1ÀÌ ³ª¿À°í ¾Æ´Ò °æ¿ì
0À» ¹ÝȯÇÑ´Ù »ý°¢ÇÏ°í ÀÖ½À´Ï´Ù µÎ¹ø°¸¦ Ç®¸é ¾î¶»°Ô ¸»ÇÏ´Â°Ô ¸ÂÁÒ?