How to quickly count total sales in excel_Introduction to the method of quickly counting total sales in excel

Want to quickly count total sales in an Excel table, but don’t know how to do it? Don't worry, PHP editor Youzi will reveal the solution for you and help you easily master the skills of quickly calculating total sales in Excel. Read on for details to get tips for achieving efficient statistics, say goodbye to tedious manual calculations, and improve your work efficiency.

1. There is now a sales table that contains sales data for multiple years, and the order is disordered. Now we are asked to quickly calculate the total sales volume this year.

2. Here we use the SUMPRODUCT function for statistics, enter =SUMPRODUCT() in the cell.

3. We first need to count this year’s information. Here the parameters are entered (YEAR(A2:A15)=YEAR(TODAY())).

4. Then multiply the calculated data by the sales array, and the function becomes =SUMPRODUCT((YEAR(A2:A15)=YEAR(TODAY()))*B2:B15 ).

5. After completing the function, the total sales volume of this year will be automatically displayed. Through this method, the total sales volume of any year can be quickly calculated.

The above is the detailed content of How to quickly count total sales in excel_Introduction to the method of quickly counting total sales in excel. For more information, please follow other related articles on the PHP Chinese website!