多种excel表格条件自动求和公式（A variety of Excel table automatic summation formula conditions）.docVIP

多种excel表格条件自动求和公式（A variety of Excel table automatic summation formula conditions） A variety of Excel table automatic summation formula conditions We do the statistics in Excel, often to use the conditional sum, the data is the statistics of certain conditions. After I had some way to search on the network, will now be in various ways as follows: Using a SUMIF (single) formula and conditions: As to the statistical data in the C column, B column data is statistical conditions as a condition. And will result in cell C6, as long as we enter the formula in cell C6 =SUMIF (B2:B5, a, C2:C5) to complete the statistics. Two, (SUM) IF (double) function condition function the nested summation: As a class of statistical production quality for the production of the total number of qualified products, and will result in cell E6, we use the conditional sum function to achieve: 1 wizard, tools and conditional sum command, in the pop-up dialog box, click the bottom right with - button, select the D1:I5 region using the mouse, and take the red arrow to window button on the right (restore dialog state). According to the next, the pop-up dialog box, click find and column on the right side of the drop-down button to select production, and then respectively according to the conditions listed, operator and comparative value on the right side of the drop-down button, select the production team , followed by = (default), a class option, then click add button. Repeat the above operation, the conditions listed, operator and comparative value is set to quality and = , qualified , and press the button add . The two click next, the pop-up dialog box, click the bottom right with - button, select the E6 cell with the mouse, and take the red arrow to the window on the right side of the button. According to the finish button, then in accordance with the terms of the summary results automatically and accurately displayed on the E6 cell. In fact, the four step is a formula can be used to complete, be