The Excel 2013 Table calculates the total monthly transaction amount based on the sales date

Case demonstration

① first, open the table, which is Evergrande real estate sales in recent months, the red is January sales, we want to quickly calculate the total January, in the G2 cell input formula: =sumproduct ((MONTH (D2:D9) =1) *e2:e9)

② carriage return, get the result, 8650000, this is the January total sales.

③ So, is there any way to verify that the results are correct? We hold down the CTRL key to select the January data, from the bottom we can see that the result is the same.

④ This example is only to demonstrate that the amount of data is small, if the amount of data is large, we recommend that you use the formula to calculate directly, rather than CTRL select cells.

Formula description

Sumproduct (array 1, array 2 ...) Array 30: In the given array, multiply the corresponding elements of the array and return the sum of the products.

Month (month): Find the month in a date.

Classification:

• Excel Tutorials