Question: How does Excel count the total loans of customers at different times?
A: Use the Sumif function as the query template.
The details are as follows: First, design a query table in the F2: G4 area of the table below. To achieve this, the total loan amount can be automatically calculated in G4 cell as long as the customer name is entered in G3 cell. (less than 1)
Then enter the SUMIF function formula in cell G3.
=sumif(b:b 12, G3, D3: d12) The sumif function has three parameters, and b:b 12 represents the area in the above table where the customer name is queried. G3 represents the name of the inquired customer, and D3:D 12 represents the loan amount area of the customer. The whole function formula means that if the customer's name is entered in cell G3, the total loan amount of the customer will be included in cell G4. (Figure 2 below)
After the above formula, press Enter, and then try to enter the customer's name in cell G3, so that you can quickly know the total loan amount of the corresponding customer. Enter the name Xiao Wang as shown below, and the total amount of loans in different periods will be displayed immediately.
Sumif function is a classical one-condition summation statistical function. In this example, the Sumif function can be used to make a simple query system template. Recommend it to everyone.
Related questions and answers: