[Google Sheets] Use useful SUBTOTAL functions for subtotal summation.
SUBTOTAL function is a useful function for calculating subtotal in Google Sheet or Excel. This function exists in Excel as well as in Google Sheet. A situation in which a SUBTOTAL() function is required Calculates the partial sum of the columns (vertical) on the sheet. We get the same total of the two below, the first total is 1,600,000 won and the second total is 1,200,000 won. If it's normal, it's right to pay 1,200,000 won like on the right. This is because the experience fee and meal fee are subtotal, so if you add them all up, it will be duplicated. 16,000,000 : The amount is added up to the subtotal, so it is an incorrect value. 1,200,000 : This is correct because subtotal is not duplicated. It's a very easy function to use in summation expressions with subtotal. How to use the SUBTOTAL() function SUBTOTAL is not necessarily a function that calculates the sum of the ranges. Various values are available as shown below, but it is recommended to remember SUM(