- Image and text skills
In our work, we often need to perform sum calculations on data at the same location in multiple worksheets in a workbook.
How to use WPS2019 to sum data in multiple worksheets?
￭Take this sales form as an example.
First of all, if we want to quickly perform calculations on multiple worksheets, we need to ensure that the data format of the worksheets must be consistent.
Place the cursor at B3 and enter =SUM('January:June'!B3) in the formula bar above.
The function of the SUM function is to return the sum of all values in a certain cell range.
January: June refers to the work schedule from January to June.
SUM('January:June'!B3) means to calculate the sum of all values in cell B3 of the worksheet from January to June.
Press Enter to confirm, and you can calculate the sum of the values in cell B3 from January to June.
Place the cursor in the lower right corner of B3 and form a cross-shaped drop-down to fill in the formula, and you can calculate the sum of values at the same location in multiple worksheets.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/duo-zhang-gong-zuo-biao-ru-he-qiu-he.html
支付宝扫一扫 
评论列表（196条）
测试