Home  >  Article  >  Software Tutorial  >  How to quickly count total sales in excel_Introduction to the method of quickly counting total sales in excel

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

PHPz
PHPzforward
2024-04-25 10:58:05972browse

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.

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

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

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

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

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

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

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

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.

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

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!

Statement:
This article is reproduced at:zol.com.cn. If there is any infringement, please contact admin@php.cn delete