title: Excel: Create sum of list, data validation drop-down list
body: <p>How can I sum all the cells of a given category, created with Data Validation List? In Microsoft Office Excel 2011.</p>
  
  <p>Example: In the C column, sum every value from that is found from the G column.</p>
  
  <p><img src="https://i.stack.imgur.com/1FnFc.png" alt="Screenshot"></p>
  
  <p>In Google Spreadsheet, I can do this with this formula:</p>
  
  <p><code>=IF(ISBLANK(F3),"",SUM(FILTER($G$3:G,$F$3:F=B3)))</code></p>
  
  <p>But in Microsoft Excel it doesn't work.</p>