How do you count and match conditional data in an Excel table?

How do you count and match conditional data in an Excel table?

1, here still use the last table, you can see the marked area, we will statistics on these areas, the most commonly used function SUM, at this time can be written as "=sum ((a1:e11=" D ") *1)", and then the array operation by Ctrl+shift+enter

2, if you are familiar with other functions, we can also use the Sumproduct function, as shown in the figure. Enter "=sumproduct ((a1:e11=" D ") *1)" To get results directly without the combination of keys

3, can also use the COUNTIF function, in the cell input "=countif" (A1:e11, "=d") "

4, since the COUNTIF can be used, we can use COUNTIFS to statistics, in the following cell input =countifs (A1:E11, "D"), but the feeling of countifs used here some of the overqualified

5, in fact, the actual encounter is more of the following figure in the table, the calculation of the region and the condition region are distinct, we can use the SUMIF function to deal with the conditions and statistical regions. Enter "=SUMIF (k1:k12," D ", l1:l12)", where k1:k12 is the conditional region, L1:L12 is the calculated summation region

6, like to use sumifs shoes can also be used here, but need to pay attention to the statistical area and the conditions of the location and sumif position exactly the opposite, judge the conditions put in the last, in the cell inside the input "=sumifs (l1:l12,k1:k12," D ")"