A story only I don't know

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(

When you use a spreadsheet, it is sometimes convenient to fix a header or title if you have more content. This time, I'm going to post how to fix the header or title. Number 1 looks like a fixed row. Number 2 is Mo that holds the heat. Fixing a Row Fixing rows is the first row of the sheet, and the second row can be fixed by default. You can also fix it based on where the current cursor is located. First, select the row you want to pin. Select View from the top menu. Select Fix . Select the menu for fixation. No row fixation : Initializes row fixation. row 1 : Fix the first row, so row 1. 2 rows ** : Fix the second row, so row 2. Up to row : You can fix it based on the currently selected row. If you select the fifth row with your mouse, you will see **until the fifth. This creates a horizontally thick gray line like above and does not scroll up. Fixing Heat Column fixation can be specified in the same way as row fixation. The method is the same as holdi