%E7%94%B5%E5%8A%A8%E9%AB%98%E5%8E%8B%E5%86%B2%E6%B4%97%E8%BD%A6%E7%9A%84%E8%BF%90%E8%BE%93%E6%B3%A8%E6%84%8F%E4%BA%8B%E9%A1%B9%E3%80%82

%E8%BF%90%E8%BE%93%E6%97%B6%E5%BA%94%E9%81%BF%E5%85%8D%E6%9B%9D%E6%99%92%E3%80%81%E9%9B%A8%E6%B7%8B%EF%BC%8C%E4%B8%8D%E5%BE%97%E4%B8%8E%E6%98%93%E7%87%83%E3%80%81%E6%98%93%E7%88%86%E3%80%81%E8%85%90%E8%9A%80%E6%80%A7%E7%89%A9%E5%93%81%E6%B7%B7%E8%A3%85%E6%B7%B7%E8%BF%90%E3%80%82%0AA.%20%E9%94%99%E8%AF%AF%0AB.%20%E6%AD%A3%E7%A1%AE%0A%E7%AD%94%E6%A1%88:%0A%0AB%0A%0A%E5%9C%A8Excel%E4%B8%AD%EF%BC%8C%E5%87%BD%E6%95%B0SUMIF%E7%9A%84%E5%8A%9F%E8%83%BD%E6%98%AF%E6%9D%A1%E4%BB%B6%E6%B1%82%E5%92%8C%E3%80%82____%0AA.%20%E9%94%99%E8%AF%AF%0AB.%20%E6%AD%A3%E7%A1%AE%0A%E7%AD%94%E6%A1%88:%0A%0AB%0A%0A%E5%9C%A8Excel%E4%B8%AD%EF%BC%8C%E8%BF%9B%E8%A1%8C%E8%87%AA%E5%8A%A8%E5%A1%AB%E5%85%85%E6%97%B6%EF%BC%8C%E9%BC%A0%E6%A0%87%E7%9A%84%E6%8C%87%E9%92%88%E4%B8%BA%E9%BB%91%E5%8D%81%E5%AD%97%E5%BD%A2%E3%80%82____%0AA.%20%E9%94%99%E8%AF%AF%0AB.%20%E6%AD%A3%E7%A1%AE%0A%E7%AD%94%E6%A1%88:%0A%0AB%0A%0A%E5%9C%A8Excel%E4%B8%AD%EF%BC%8C%E8%8B%A5%E8%A6%81%E5%AF%B9%E6%9F%90%E5%B7%A5%E4%BD%9C%E8%A1%A8%E9%87%8D%E6%96%B0%E5%91%BD%E5%90%8D%EF%BC%8C%E5%8F%AF%E4%BB%A5%E9%87%87%E7%94%A8%E5%8F%8C%E5%87%BB%E5%B7%A5%E4%BD%9C%E8%A1%A8%E6%A0%87%E7%AD%BE%E3%80%82____%0AA.%20%E9%94%99%E8%AF%AF%0AB.%20%E6%AD%A3%E7%A1%AE%0A%E7%AD%94%E6%A1%88:%0A%0AB%0A%0A%E5%9C%A8Excel%E4%B8%AD%EF%BC%8C%E5%BD%93%E5%9C%A8%E6%9F%90%E5%8D%95%E5%85%83%E6%A0%BC%E5%86%85%E8%BE%93%E5%85%A5%E5%85%AC%E5%BC%8F%E5%B9%B6%E7%A1%AE%E8%AE%A4%E5%90%8E%EF%BC%8C%E5%8D%95%E5%85%83%E6%A0%BC%E5%86%85%E5%AE%B9%E6%98%BE%E7%A4%BA%E4%B8%BA