How to subtotal data in excel and show only the result code#

When we need to include hidden values for calculation, choose the corresponding function code in the includes hidden values column. How this differs from other functions is. The result of this function repeats the running total in column E, but itвЂ™s easier to discern the daily subtotal when separated from the other daily totals. When we need to ignore the hidden value of the table for calculation, use the function code in the ignores hidden values column. Using the subtotal function, you can perform a number of calculations and keep them in line with the rest of your data. SUBTOTAL is often used to calculate the hidden value in the table. After we get the result, hide the highest and lowest scores. E nter the corresponding AVERAGE function code 101 and select the reference cell range C3: C9.ДЈ. Now, we only need to click to insert the SUBTOTAL function. To make the result closer to the actual situation, we usually choose to ignore the highest and lowest data.ДЎ. Now we need to calculate the average grade of this study group. These are the grades of some students in a study group.

In addition, we can also use the SUBTOTAL function in many scenarios. That is to say, only the data of the display unit will be calculated. When we hide other data, the calculation result will change accordingly. Select the cell range A1: A7 in the reference, and click OK to get the result.ДЄt this time, the calculation result will not include the hidden cell data. E nter the function code 109 of ignores hidden values of SUM function in the function number.ДЈ. Its corresponding function code is also shown in the table in this video.ДЎ. Next, we are going to show you the usage of the SUBTOTAL function. In this case, we can use the SUBTOTAL function. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value.