You can do some special tasks using this feature. Now, I am going to show you an amazing Subtotal feature available in Excel. Utilizing Subtotal Feature to Make Subtotal and Grand Total Read More: How to Insert Subtotals in Excelģ. When I divided it by 2, it would return the actual grand total as subtotal values are available there. Here, the SUM function returns all the sum values. So, the formula for the F8 cell will be like the following. ➜ Then, select the cells ( F5:F7) of Product A. From there, you need to select 9 as you’re going to compute the sum of the Sales. ➜ While entering the formula, you’ll see some groups of functions. Now, you have to insert the SUBTOTAL function. That’s the main difference between subtotal and grand total! In addition, you can determine the grand total (in the F17 cell) for all groups of products. That means you can find the subtotal for only P roduct A (in the F8 cell). ⧬ Let’s assume that you want to find the subtotal for the group of products (i.e. SUBTOTAL function to calculate subtotal covering 11 mathematical operations e.g. Luckily, there is a dedication function i.e. Using SUBTOTAL Function to Make Subtotal and Grand Total The first two methods use Excel functions and the rest methods focus on the use of some fruitful features of Excel.ġ. Now, you’ll explore the methods to make subtotal and grand total (for the Sales column) in the case of the above dataset. Product Items, States, Price, Quantity, and lastly Sales. Here, the sales report is given along with the necessary information e.g. Let’s introduce today’s dataset (which belongs to the B4:F13 cell range) as shown in the following screenshot. Related Articles How to Make Subtotal and Grand Total in Excel: 4 Methods
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |