正确使用Excel六大条件语句或函数功能（Use the six conditional statements or function functions correctly）.docVIP

正确使用Excel六大条件语句或函数功能（Use the six conditional statements or function functions correctly） Use the six conditional statements or function functions correctly The sum of the conditions. 1, single condition sum: statistical C1 company construction project total construction area, and put the results in E18 cell, we as long as the input in the E18 cell formula = SUMIF (D2: D17, C1 , E2: E17) the statistics is completed. Note: if the Excel function is not very familiar with, it is hard to enter the formula within the cell, we can use the insert function command (or press the paste function command button on the toolbar), select the function you need, according to the prompt operation can complete formula of input. More than 2, conditional sum: statistical C2 company quality level for construction project total construction area of qualified, and put the results in, cell we use conditional sum function to achieve: (1) select tools - the wizard - conditional sum command (without the command options, you can use add-ins way to increase the command options), in the pop-up dialog box, press the lower right with - button (when the window of the dialog into a similar toolbar form floating on the surface of the table), use the mouse to the selected D1: I17 area, and according to the window with a red arrow on the right button (restore dialog state). (2) press next, in the pop-up dialog box, press the sum to the right of the drop-down button to select construction area, and then respectively according to the condition of column, operator, comparative value to the right of the drop-down button and, in turn, select the construction unit, = (the default), C2 company option, finally press the add button. Repeat the above operation to set condition column, operator, comparison value to quality level, =, qualified and press add condition button. Twice click next, in the pop-up dialog box, press the - button on the lower right, select the E19 cell with the mouse, and press the button wit