[¿¢¼¿2007] »õ·Î¿îÇÔ¼ö sumifs
* sumifs ÀÇ Á¤ÀÇ
: ÃÖ´ë 127°³Á¶°Ç°¡´ÉÀÇ ¹üÀ§³»¿¡¼ ¿©·¯Á¶°ÇÀ» ¸¸Á·ÇÏ´Â ¼¿ÀÇ ÇÕ°è
[»ç¿ë¿¹]
¼ö½Ä : SUMIFS($E$21:$E$26,$C$21:$C$26,B29,D21:D26,C29)
¼³¸í : 1. $E$21:$E$26´Â Çհ踦 ±¸ÇÒ ±Þ¿©¾×ÀÌ ÀԷµǾî ÀÖ´Â ¹üÀ§ÀÔ´Ï´Ù.
2. $C$21:$C$26´Â Á¶°ÇÀÇ ÂüÁ¶¹üÀ§ÀÌ°í Á¶°Ç B29(Ãѹ«ºÎ)¸¦ ÀÔ·ÂÇÕ´Ï´Ù.
3. ¼¿ ¹üÀ§¿¡ [$]¸¦ Àû¿ëÇÑ°ÍÀº Çѹø ÀÔ·ÂµÈ ¼¿ÀÇ µå·¡±×½Ã ¿òÁ÷ÀÌÁö ¾Êµµ·Ï Çϱâ À§ÇÔÀÔ´Ï´Ù.
4. Á¶°ÇÀº ÃÖ´ë 127°³ ±îÁö °¡´ÉÇϹǷΠ[$C$21:$C$26,B29,D21:D26,C29]°ú °°ÀÌ Á¶°ÇÀ»
ÀÌ¾î¼ ÀÔ·ÂÇÏ½Ã¸é µË´Ï´Ù.