엑셀 2013버전 질문 드립니다...(중복 조건 갯수)

<div>  <img src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAkoAAAFZCAYAAABniQAxAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAACKSSURBVHhe7d3PjzXLfRfgM6xhB154D9cSW/ZeGUQAAUIiRCyIFTn5A+IrG8UgUGzsGCfYSIAiK2AIthMsBAgIAm/m7tki2bBhxcIs7PjXve/19ftmajz13n5rqrq/dbrPvF19nudV6Z7TXb9s9fT5TPXpnpsXd04AADzyxx7+CwBAQVACAGgQlAAAGjYLSt/73vceXgHANny2cCnRY2uzoPT8+fOHVwCwDZ8tXEr02NosKLl5DoCt+WzhUqLHlhUlAHbLZwuXEj22NnuO0ne+853TBz7wgYd3QMtHPvKRh1en0ze/+c2HV0CNz5Zl03NK5tyyLHpsWVGCJ5ROaOkElkvtBAe8z2dLzPS84twSEz22fEcJnkgOSVNOaDDPZwuX4jtKAAzPZ8t5/BK2zIoSDKJcZQLe57OFS7GiBMDwfLZwKVaUABiezxYuxYoSAMPz2cKlWFGCQfjCJbT5bOFSrCgBMDyfLeepPY6EV1lRgp2p3a7rZAbzfLZwKdFja7M/YfLtb3/79MYbbzy8A1qmYUlIgnk+W5bVLt87tyyLHlubBaVvfetbpw996EMP7wBgPZ8tXEr02PIdJQB2y2cLlxI9tm6+8Y1vuAAMAFBx8+J//vYmQemtH75x+vAf//bDOwBYz2cLlxI9tja79AYAcDSCEgBAg6AEANAgKAEANAhKAAANghIAQIPHA8AGbv7cr5zufpYe3sVN27X6SNtLZb1zx4e9O/JnS+1nu6b1sx1tn0TPGeX2I59boseWoAQzWieinpNOqXUSWnNCWtMW9sxnS9/Pd7Ruq17aXjrquSV6bLn0BjPSCaJWaieTmjVtAXrk8BM9x6R6ZUmm5yvu/n+6+z/ixdf/7wcf3p7vg3/yT1hR4mqkE8r0JFK+nzOt23qdpPdLWm1hD3y29Gn9HC/9fOdzRe380WoXHWtp7NflKY+tl0Hpb/2Nv/ywqd/v/fv/IihxVdacTKZ1W69r5vb3jA9PxWdLn9rPcetnO23PpvvL+tF62bR+Vqv3uj3lsfX+pbcXL84vcIXSCSUXoKH2mREtNENK2p7LnFa99H56DstlWr9sszu1YyZaOrxcUfr5v/6XHjb1+/3/8F+tKHFV8gklK99PpX1TZbupuRNTbcypubbwOvhsaSt/fiPmfv4jzjlHlOedvXjKY+tlUPqbf+3nHjb1+3f/8Q8EJa5G7cTROpksnWSm++fq5n3njgOvQ89ny+d+4wunT37i4w/vfsZny+u313NL69j67Of/8cOru2D4/MXp+fOfnn76/Pnp+U/v/ntX3vvpe6fPfeYzXcfWy0tvtZWpaAGAmtpnRq288+ydR9uuSQokZelxTvtam7Ls+Rew8nhJ5ZNvvnkfkN57773TT37yk9NP3r0rz949PXv27L589tOfua/X4/2gtOIfXIvXceKYjpn+m97DKKafFXP/nr1zF5SKf9dgGkjKkvfNWdO+1qYsS+O/TtNjZfrvk5948/ReCkjv3gWkd+8C0l159678xuc++7JOj5dB6fldxJqWz33+Cy/LZ/7R507/4B/++unv/tqnTr/68Tcf1YWjm56MtrB0AstqY+795AVT5edFq7z9ztuPth1d/vlunVfyvtbP+9r2Sdo3V1p970F5vEzL3/v7nzq987CK9OzZO6fPf/7zr+zv0bz09ubHf/X+et47b799+uGPfnj6wQ++f/rB979/P1hZF46oPFmcc8LIJ6myRPrL9Wpyv7B35edFq7x991lTbuOypueiVtmz8ngpSwpIKSi9886zR/t6vB+Unr94VD7x5pt3A7x9+v4f/uFd+f7pi//ki9V6cERbnSym/fT0t1Qv2g+8TrXPjFpJv5SX244u/QznX55q8r7Wz/ra9qMrj5eyPLsLSPflLiyV+3q8vOvtr/7cX3jY9Ngv/dJHT7/zO//q4d1j/+kP/rs7E7hq556Mpu3WnNCOfDJkXOVny2/+1m/e//fdZ+/eryD96Mc/PP3mF37r9NGP/uL9FYxUvvrVr93XSa7psyX9DJd6fqbPbV9rV9rjuWV6bLWOq1/+5Y/dHVPv3R9XX/nKv7mvk/UcWy+D0l/5i3/+YVO///zf/oegBMArap8tn/70r59+/OMfn370ox+dvvSlf/qw9XT6hV/4+dPXv/77D+9+xmcLLeWxVTuuPvqLf+dnAfx5CuBfv9+W9Rxb7noD4GKmnxXp36996lOn7373u6cvfulLk60vTl/7+u9N3v3sH8yZHiu14+pffuUrp3/9u797+rdf/drLbflfj+aXuXsKANTUPjP+2T//F9XtZYE55fESPa5S6TEJSncZ68wCADW1z4xogTm1YyZaelhRAuBiap8Z0QJzasdMtPR4+WXutXzhDoApny1cylMeW/dB6eH1Km/98A0HMwCb8tnCpUSPrZsvf/nLmwQlAICjuXnR+62mhrfeeuv04Q9/+OEdAKyXPlu+/H/+1MM72M7H/vT/D+WWl1/mBgDgVYISAECDS28A7NbIl96++rE/+/Bq2d/+8v96ePW+WvuyXqoTbZtE25cicxlN9NLbK0Hp5ubmdG5umgtKa/oF4Hod7TtK0WAS1dtfWX/r+YxkLihNc8t9UEobMkEJgL04UlDKoWQpnKT9S3L73qBT1p9rH5lH1jOHvagFpVoesqIEwG4dISjlwFEGlGRtwJiGmUhftfDTM4fUfsRQVNO1onT/6s4lglLuU1gCoNeoQakVYMqgMRd0IqGmN7jUxo+0z3NJdaevRyYoATC8I6woTfUEk1q9cnu0v6RWd6592pe15pJF57AnghIAwzvCilLUNGy0Aky5vVWvFO3vmuwiKJX9CUsA9DjailKPFGJKZahZCjq5j1aduQDVa7TAJSgBMLyjBKVI6NnKdKylMVpBqaW3/p5Fg9LFn8ydBssFAK5JChY5XJQl72uZ25fV6kzHYL2LrSi1+lozBgDXZeQVpRyQlrTqRYJS0hojOn7L2vH37rVfehOUAFjr2oPSUvu5OtHx13qqcba2m0tvAHCNUnhIISKVmrxvxJBxTV5ZUVqjXFECgLVGXlGaqoWlSEBqhaxsqY+l9snaoDZq2JtbUZoSlADYraMEJfYnGpRcegMAaLi5vb31zWoAgAqX3gDYLZfeuBSX3gAAVhKUAAAaXHoDYLdGvvQWuTU/q91eH3mkQOvW/NbY0falyFxGc9bjAbZ8MveUp3EDcI6jfUcpGkyievsr6289n5FEn8x9H5TShkxQAmAvjhSUcihZCidp/5LcvjfolPXn2kfmkfXMYS9qQamWh6woAbBbRwhKOXCUASVZGzCmYSbSVy389MwhtR8xFNV0rSjdv7pziaCU+xSWAOg1alBqBZgyaMwFnUio6Q0utfEj7fNcUt3p65EJSgAM7wgrSlM9waRWr9we7S+p1Z1rn/Zlrblk0TnsiaAEwPCOsKIUNQ0brQBTbm/VK0X7uya7CEplf8ISAD2OtqLUI4WYUhlqloJO7qNVZy5A9RotcAlKAAzvKEEpEnq2Mh1raYxWUGrprb9n0aB08Sdzp8FyAYBrkoJFDhdlyfta5vZltTrTMVjvYitKrb7WjAHAdRl5RSkHpCWtepGglLTGiI7fsnb8vXvtl94EJQDWuvagtNR+rk50/LWeapyt7ebSGwBcoxQeUohIpSbvGzFkXJNXVpTWKFeUAGCtkVeUpmphKRKQWiErW+pjqX2yNqiNGvbmVpSmBCUAdusoQYn9iQYll94AABpubm9vfbMaAKDCpTcAdsulNy7FpTcAgJUEJQCABpfeANitkS+9RW7Nz2q310ceKdC6Nb81drR9KTKX0Zz1eIAtn8w95WncAJzjaN9RigaTqN7+yvpbz2ck0Sdz3weltCETlADYiyMFpRxKlsJJ2r8kt+8NOmX9ufaReWQ9c9iLWlCq5SErSgDs1hGCUg4cZUBJ1gaMaZiJ9FULPz1zSO1HDEU1XStK96/uXCIo5T6FJQB6jRqUWgGmDBpzQScSanqDS238SPs8l1R3+npkghIAwzvCitJUTzCp1Su3R/tLanXn2qd9WWsuWXQOeyIoATC8I6woRU3DRivAlNtb9UrR/q7JLoJS2Z+wBECPo60o9UghplSGmqWgk/to1ZkLUL1GC1yCEgDDO0pQioSerUzHWhqjFZRaeuvvWTQoXfzJ3GmwXADgmqRgkcNFWfK+lrl9Wa3OdAzWu9iKUquvNWMAcF1GXlHKAWlJq14kKCWtMaLjt6wdf+9e+6U3QQmAta49KC21n6sTHX+tpxpna7u59AYA1yiFhxQiUqnJ+0YMGdfklRWlNcoVJQBYa+QVpalaWIoEpFbIypb6WGqfrA1qo4a9uRWlKUEJgN06SlBif6JByaU3AICGm9vbW9+sBgCocOkNgN1y6Y1LcekNAGAlQQkAoMGlNwB2a+RLb5Fb87Pa7fWRRwq0bs1vjR1tX4rMZTRnPR5gyydzT3kaNwDnONp3lKLBJKq3v7L+1vMZSfTJ3PdBKW3IBCUA9uJIQSmHkqVwkvYvye17g05Zf659ZB5Zzxz2ohaUannIihIAu3WEoJQDRxlQkrUBYxpmIn3Vwk/PHFL7EUNRTdeK0v2rO5cISrlPYQmAXqMGpVaAKYPGXNCJhJre4FIbP9I+zyXVnb4emaAEwPCOsKI01RNMavXK7dH+klrdufZpX9aaSxadw54ISgAM7wgrSlHTsNEKMOX2Vr1StL9rsougVPYnLAHQ42grSj1SiCmVoWYp6OQ+WnXmAlSv0QKXoATA8I4SlCKhZyvTsZbGaAWllt76exYNShd/MncaLBcAuCYpWORwUZa8r2VuX1arMx2D9S62otTqa80YAFyXkVeUckBa0qoXCUpJa4zo+C1rx9+7137pTVACYK1rD0pL7efqRMdf66nG2dpuLr0BwDVK4SGFiFRq8r4RQ8Y1eWVFaY1yRQkA1hp5RWmqFpYiAakVsrKlPpbaJ2uD2qhhb25FaUpQAmC3jhKU2J9oUHLpDQCg4eb29tY3qwEAKlx6A2C3XHrjUlx6AwBYSVACAGhw6Q2A3Rr50lvk1vysdnt95JECrVvzW2NH25cicxlN1+MB0hMop87JTnNBydO4ATjH0b6jFA0mUb39lfW3ns9Iok/mTgkpZaX7N9k5wUZQAmBrRwpKOZQshZO0f0lu3xt0yvpz7SPzyHrmsBe1oDRdOBKUANi9IwSlHDjKgJKsDRjTMBPpqxZ+euaQ2o8Yimp2s6KU+xKWAOg1alBqBZgyaMwFnUio6Q0utfEj7fNcUt3p65EJSgAM7wgrSlM9waRWr9we7S+p1Z1rn/Zlrblk0TnsSTgo3b246Je5BSUAznWEFaWoadhoBZhye6teKdrfNdnFilLZj7AEQI+jrSj1SCGmVIaapaCT+2jVmQtQvUYLXIISAMM7SlCKhJ6tTMdaGqMVlFp66+9ZNChd/MncabBcAOCapGCRw0VZ8r6WuX1Zrc50DNa72IpSq49z+gbgOo28opQD0pJWvUhQSlpjRMdvWTv+3r32S2+CEgBrXXtQWmo/Vyc6/lpPNc7Wwpfe0ou0YVoEGQBYJ4WHFCJSqcn7RgwZ18QfxQVgt0ZeUZqqhaVIQGqFrGypj6X2ydqgNmrYm1tRmhKUANitowQl9icalC5+1xsAwKhubm9vfSEJAKDCpTcAdsulNy7FpTcAgJUEJQCABpfeANitkS+9RW7Nz2q310ceKdC6Nb81drR9KTKX0SxdesvPlXwZlNKG7JzsNBeUPMQSgHMc7TtK0WAS1dtfWX/r+Ywk+mTu+6BUBplzgo2gBMDWjhSUcihZCidp/5LcvjfolPXn2kfmkfXMYS9aQelRJrord+8fh5jecCMoAbC1IwSlHDjKgJKsDRjTMBPpqxZ+euaQ2o8Yimp2E5RyP8ISAL1GDUqtAFMGjbmgEwk1vcGlNn6kfZ5Lqjt9PbJaUKplFUEJgN06worSVE8wqdUrt0f7S2p159qnfVlrLll0DnsiKAEwvCOsKEVNw0YrwJTbW/VK0f6uyS6CUtmHsARAj6OtKPVIIaZUhpqloJP7aNWZC1C9RgtcghIAwztKUIqEnq1Mx1oaoxWUWnrr71k0KF38ydxp0FwA4JqkYJHDRVnyvpa5fVmtznQM1rvYilKrfW+/AFyvkVeUckBa0qoXCUpJa4zo+C1rx9+72opSUuaUiz1wUlACYK1rD0pL7efqRMdf66nG2Vo0KN1feksb0o5cBBkAWCeFhxQiUqnJ+0YMGUeWM1Hmj+ICsFsjryhN1cJSJCC1Qla21MdS+2RtUBs17LVWlLK8cCQoAbBbRwlK7M9SUMouftcbAMCobm5vb30hCQCgwqU3AHbLpTcuxaU3AICVBCUAgAaX3gDYrZEvvUVuzc9qt9dHHinQujW/NXa0fSkyl9F0Px5g+nClc7JTGZSm/WUbZTIArsTRvqMUDSZRvf2V9beez0jmglIOSfevU1CabkjK9xG1oFT2cU6/AFyvIwWlHEqWwknavyS37w06Zf259pF5ZD1z2ItWUHqUie7K3fvH4aU31ESCUiIsARB1hKCUA0cZUJK1AWMaZiJ91cJPzxxS+xFDUY2gBMDwRg1KrQBTBo25oBMJNb3BpTZ+pH2eS6o7fT2yWlCqZZQnDUpCEgA9jrCiNNUTTGr1yu3R/pJa3bn2aV/WmksWncOe7CIolYQkAHocYUUpaho2WgGm3N6qV4r2d02sKAEwvKOtKPVIIaZUhpqloJP7aNWZC1C9RgtcuwxKibAEQNRRglIk9GxlOtbSGK2g1NJbf8+iQcmTuQHgQlKwyOGiLHlfy9y+rFZnOgbrWVECYLdGXlHKAWlJq14kKCWtMaLjt6wdf+9qK0pJmVM8cBKA3br2oLTUfq5OdPy1nmqcrUWD0v2lt7Qh7chlqzAz7XPLfgFg71J4SCEilZq8b8SQcWQ5E2X+KC4AuzXyitJULSxFAlIrZGVLfSy1T9YGtVHDXmtFKcsLPIISALt1lKDE/iwFpcxdbwAADTe3t7e+OAQAUOHSGwC75dIbl+LSGwDASoISAECDS28A7NbIl94it+ZntdvrI48UaN2a3xo72r4Umctouh8PMH240jnZqQxK0/6yjTIZAFfiaN9RigaTqN7+yvpbz2ckc0Eph6T71ykoTTck5fuIWlAq+zinXwCu15GCUg4lS+Ek7V+S2/cGnbL+XPvIPLKeOexFKyg9ykR35e794/DSG2oiQSkRlgCIOkJQyoGjDCjJ2oAxDTORvmrhp2cOqf2IoahGUAJgeKMGpVaAKYPGXNCJhJre4FIbP9I+zyXVnb4eWS0o1TLKkwYlIQmAHkdYUZrqCSa1euX2aH9Jre5c+7Qva80li85hT3YRlEpCEgA9jrCiFDUNG60AU25v1StF+7smVpQAGN7RVpR6pBBTKkPNUtDJfbTqzAWoXqMFrl0GpURYAiDqKEEpEnq2Mh1raYxWUGrprb9n0aDkydwAcCEpWORwUZa8r2VuX1arMx2D9awoAbBbI68o5YC0pFUvEpSS1hjR8VvWjr93tRWlpMwpHjgJwG5de1Baaj9XJzr+Wk81ztaiQen+0lvakHbkslWYmfa5Zb8AsHcpPKQQkUpN3jdiyDiynIkyfxQXgN0aeUVpqhaWIgGpFbKypT6W2idrg9qoYa+1opTlBR5BCYDdOkpQYn+WglLmrjcAgIab29tbXxwCAKhw6Q2A3XLpjUtx6Q0AYCVBCQCgwaU3AHZr5EtvkVvzs9rt9ZFHCrRuzW+NHW1fisxlNN2PB5g+XOmc7FQGpWl/2UaZDIArcbTvKEWDSVRvf2X9reczkrmglEPS/esUlKYbkvJ9RC0olX2c0y8A1+tIQSmHkqVwkvYvye17g05Zf659ZB5Zzxz2ohWUHmWiu3L3/nF46Q01kaCUCEsARB0hKOXAUQaUZG3AmIaZSF+18NMzh9R+xFBUIygBMLxRg1IrwJRBYy7oREJNb3CpjR9pn+eS6k5fj6wWlGoZ5UmDkpAEQI8jrChN9QSTWr1ye7S/pFZ3rn3al7XmkkXnsCe7CEolIQmAHkdYUYqaho1WgCm3t+qVov1dEytKAAzvaCtKPVKIKZWhZino5D5adeYCVK/RAtcug1IiLAEQdZSgFAk9W5mOtTRGKyi19Nbfs2hQ8mRuALiQFCxyuChL3tcyty+r1ZmOwXpWlADYrZFXlHJAWtKqFwlKSWuM6Pgta8ffu9qKUlLmFA+cBGC3rj0oLbWfqxMdf62nGmdr0aB0f+ktbUg7ctkqzEz73LJfANi7FB5SiEilJu8bMWQcWc5EmT+KC8BujbyiNFULS5GA1ApZ2VIfS+2TtUFt1LDXWlHK8gKPoATAbh0lKLE/S0Epc9cbAEDDze3trS8OAQBUuPQGwG659MaluPQGALCSoAQA0ODSGwC7NfKlt8it+Vnt9vrIIwVat+a3xo62L0XmMpruxwNMH650TnYqg9K0v2yjTAbAlTjad5SiwSSqt7+y/tbzGclcUMoh6f51CkrTDUn5PqIWlMo+zukXgOt1pKCUQ8lSOEn7l+T2vUGnrD/XPjKPrGcOe9EKSo8y0V25e/84vPSGmkhQSoQlAKKOEJRy4CgDSrI2YEzDTKSvWvjpmUNqP2IoqhGUABjeqEGpFWDKoDEXdCKhpje41MaPtM9zSXWnr0dWC0q1jPKkQUlIAqDHEVaUpnqCSa1euT3aX1KrO9c+7ctac8mic9iTXQSlkpAEQI8jrChFTcNGK8CU21v1StH+rokVJQCGd7QVpR4pxJTKULMUdHIfrTpzAarXaIFrl0EpEZYAiDpKUIqEnq1Mx1oaoxWUWnrr71k0KHkyNwBcSAoWOVyUJe9rmduX1epMx2A9K0oA7NbIK0o5IC1p1YsEpaQ1RnT8lrXj711tRSkpc4oHTgKwW9celJbaz9WJjr/WU42ztWhQur/0ljakHblsFWamfW7ZLwDsXQoPKUSkUpP3jRgyjixnoswfxQVgt0ZeUZqqhaVIQGqFrGypj6X2ydqgNmrYa60oZXmBR1ACYLeOEpTYn6WglLnrDQCg4eb29tYXhwAAKlx6A2C3XHrjUlx6AwBYSVACAGhw6Q2A3Rr50lvk1vysdnt95JECrVvzW2NH25cicxlN9+MBpg9XOic7tYLS2n4BuF5H+45SNJhE9fZX1t96PiOZC0o5JN2/TkFpuiEp30fUgtIW/QJwvY4UlHIoWQonaf+S3L436JT159pH5pH1zGEvWkHpUXa5K3fvH4eX3lBTBqVWe2EJgKgjBKUcOMqAkqwNGNMwE+mrFn565pDajxiKagQlAIY3alBqBZgyaMwFnUio6Q0utfEj7fNcUt3p65HVglItozx5UAKAqCOsKE31BJNavXJ7tL+kVneufdqXteaSReewJ4ISAMM7wopS1DRstAJMub1VrxTt75oISgAM72grSj1SiCmVoWYp6OQ+WnXmAlSv0QKXoATA8I4SlCKhZyvTsZbGaAWllt76exYNSk/+ZO40CQC4BilY5HBRlryvZW5fVqszHYP1nnxFyUoTAFEjryjlgLSkVS8SlJLWGNHxW9aOv3e1FaWkzCkeOAnAbl17UFpqP1cnOv5aTzXO1qJB6f7SW9qQduSyVZi5VL8AsHcpPKQQkUpN3jdiyDiynF0yfxQXgN0aeUVpqhaWIgGpFbKypT6W2idrg9qoYa+1opTlBR5BCYDdOkpQYn+WglL25He9AQCM4ub29tYXhwAAKlx6A2C3XHrjUlx6AwBYSVACAGhw6Q2A3Rr50lvk1vysdnt95JECrVvzW2NH25cicxlN9+MBpg9XOic7tYLS2n4BuF5H+45SNJhE9fZX1t96PiOZC0o5JN2/TkFpuiEp30fUgtIW/QJwvY4UlHIoWQonaf+S3L436JT159pH5pH1zGEvWkHpUXa5K3fvH4eX3lBTBqVWe2EJgKgjBKUcOMqAkqwNGNMwE+mrFn565pDajxiKagQlAIY3alBqBZgyaMwFnUio6Q0utfEj7fNcUt3p65HVglItozx5UAKAqCOsKE31BJNavXJ7tL+kVneufdqXteaSReewJ4ISAMM7wopS1DRstAJMub1VrxTt75oISgAM72grSj1SiCmVoWYp6OQ+WnXmAlSv0QKXoATA8I4SlCKhZyvTsZbGaAWllt76exYNSk/+ZO40CQC4BilY5HBRlryvZW5fVqszHYP1nnxFyUoTAFEjryjlgLSkVS8SlJLWGNHxW9aOv3e1FaWkzCkeOAnAbl17UFpqP1cnOv5aTzXO1qJB6f7SW9qQduSyVZi5VL8AsHcpPKQQkUpN3jdiyDiynF0yfxQXgN0aeUVpqhaWIgGpFbKypT6W2idrg9qoYa+1opTlBR5BCYDdOkpQYn+WglL25He9AQCM4ub29tYXhwAAKlx6A2C3XHrjUlx6AwBYSVACAGhw6Q2A3Rr50lvk1vysdnt95JECrVvzW2NH25cicxlN9+MBpg9XOic7tYLS2n4BuF5H+45SNJhE9fZX1t96PiOZC0o5JN2/TkFpuiEp30fUgtIW/QJwvY4UlHIoWQonaf+S3L436JT159pH5pH1zGEvWkHpUXa5K3fvH4eX3lBTBqVWe2EJgKgjBKUcOMqAkqwNGNMwE+mrFn565pDajxiKagQlAIY3alBqBZgyaMwFnUio6Q0utfEj7fNcUt3p65HVglItozx5UAKAqCOsKE31BJNavXJ7tL+kVneufdqXteaSReewJ4ISAMM7wopS1DRstAJMub1VrxTt75oISgAM72grSj1SiCmVoWYp6OQ+WnXmAlSv0QKXoATA8I4SlCKhZyvTsZbGaAWllt76exYNSk/+ZO40CQC4BilY5HBRlryvZW5fVqszHYP1nnxFyUoTAFEjryjlgLSkVS8SlJLWGNHxW9aOv3e1FaWkzCkeOAnAbl17UFpqP1cnOv5aTzXO1qJB6f7SW9qQduSyVZi5VL8AsHcpPKQQkUpN3jdiyDiynF0yfxQXgN0aeUVpqhaWIgGpFbKypT6W2idrg9qoYa+1opTlBR5BCYDdOkpQYn+WglL25He9AQCM4ub29tYXhwAAKm5e/L/fFpQA2KW3/vcbpw//mW8/vIPtRI8tl94AABoEJQCABkGJkJsP/sorpVfZvtZHbdsWpv32jpHnmgsA18V3lAhJIeHuWHl4dxnnjlELMNN+pv2u+d/xFP8fAK/yHaXjq51ba+f1pDy3T/Wen6PHlqBEyLkhoXWwT+V+zx2jZtpX63WvLecHxAhKx5XOqVnk3Lp0Lu89R/syN7uQDtqlMpUO9OkPzxpb9gXAtmqfAS29IWhLghJPIoeWaanp+cFZsmVfAOzbpc73ghIXl0JRDi3T0gpLAJDlz5DXRVACAIaTr07kcimCEheXV4/KcqnfEFLf+b/5NQDHkq9O5HKp872gxJMoD+hUSrVt55obB4AxXPKX6ihBiScRSfpb/Dawhx8qAI5DUOLJpBAzV9ZKfQhJAGxJUOLJ5EthrXKOadA6tw8AaBGUGNraoAXAeNI5f/qL8iV/WfYnTAhJB+HUOQdk2UfpYgf55Aeo94dpi//dwPn8CRMuxd96A2B4ghKX4m+9AQCsdHN7e2tFCQCg4ubFnYfXq9zc3Jw26goA4KKiuWWzS29CEgBbSx9mcAnR3LJZUHIwA7A1v4RzKdHcYkUJgN3ySziXYkUJgOH5JZxLsaIEwPD8Es6lWFECYHh+CedSrCgBMDy/hHMpVpQAGJ5fwrkUK0oADM8v4VyKFSUAhueXcC7FihIAw/NLOJdiRQmA4fklnEuJ5ZbT6Y8AJdEy+9uu9WQAAAAASUVORK5CYII="> </div>현재 d열의 필터로 '종합건축'만 정렬을 시켜놓았습니다.(종합건축 이외 다른 공종도 있습니다)제가 원하는 데이터는 '종합건축'에 해당하는 거래처 'A'의 갯수를 알고싶습니다... 엑셀초보라서 그냥 무작정 =SUMIF(D1:D500,D2,COUNTIF(C1:C500,"=A")) 로해봤는데 수식오류가 떠서요..ㅠㅠ