When you want to exclude double counting of sum where subtotals are already included in the data, there are 2 simple ways you can sum the data without any duplication. The first one is just sum the entire range and divide by 2. The other option is if your subtotals withing the data range are calculated using the subtotal function in excel, then even for grand total, you can use the subtotal function. check it out. By the way, there is an even better function called the aggregate function. Check it out.

Connect:
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
Subscribe: [ Ссылка ]

Course Alert:
If you would like to learn in detail, how to calculate sales variances and the impact they have on sales $, profit $ and profit margin %, and how to explain performance vs budget and prior periods, click on the link for a detailed video course (at a special price). You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates. [ Ссылка ]

Videos you may like:
Learn sales and profitability analysis in detail here: [ Ссылка ]
Gross profit and gross profit margin explained: [ Ссылка ]
How calculate selling price and profits on Etsy: [ Ссылка ]
Standard Margin and Actual Margin - the Difference: [ Ссылка ]
How calculate selling price and profits on Etsy: [ Ссылка ]

Some Recommendations:
Are you a First Time or New Manager? Check this out: [ Ссылка ]
Learn pivot table data crunching business skills here: [ Ссылка ]
Learn all about Excel in one place: [ Ссылка ]
Learn what financial numbers really mean here: [ Ссылка ]
Accounting explained in 100 pages or Less: [ Ссылка ]
Note: At no extra cost to you, I may receive some commission if you purchase using the links above.

Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance.

#excetips #excelformulas #excelfunctions #subtotal #aggregate #sumfunction #excel

свернуть