What is the Excel conditional sum formula?

Conditional summation uses formulas to sum based on specific conditions. When summing a single condition, you need to use the SUMIF function, and when summing multiple conditions, use the SUMIFS function.

SUMIF function

SUMIF (conditional judgment area, condition, summation area)

Note: The SUMIF function can only take one condition, and its format is judgment area, condition, Summing area.

Explanation: Conditional judgment area: it is the conditional area for summation; condition: summation condition; summation area: the reference cell area for the summation shown.

Example: "=SUMIF(A:A,B2,C:C)" This is a single-condition summation formula. A:A is the conditional area, B2 is the condition, and C:C is the summation. Area. Of course, the condition here can be a certain value, a certain cell, or some other conditions, such as ">12" and so on. "=SUMIFS(C:C,A:A,>1,B:B,F1)" This is a multi-condition summation formula. At this time, C:C is the summation area and A:A is the conditional area. , >1 is condition one, B:B is condition area two, and F1 is condition two.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column to learn!

The above is the detailed content of What is the Excel conditional sum formula?. For more information, please follow other related articles on the PHP Chinese website!