Quick Trick Adds Excel Grand Total Formulas Automatically

✅ Get the sample Excel file to follow along ► myctx.link/SUM
🔵 Use this quick trick to get totals for rows, columns and the grand total. Excel automatically adds the formula in each cell!
💡 Related Links 💡
Excel Sum Formula Examples ► myctx.link/SUM
More Excel Tips & Videos ► myctx.link/TipsXL
🔴 Related Excel Videos 🔴
Copy Formulas in Excel Tables ► • Copy Excel Formulas wi...
7 Ways to Sum in Excel ► • 7 Ways to Sum in Excel
✅ Excel resources I recommend ► myctx.link/xlpick
🔶 Instructor: Debra Dalgleish, Contextures Inc.
💡 Get Debra's monthly Excel tips: www.contextures...
Subscribe to Contextures RUclips: www.youtube.co...
#ContexturesExcelTips

[@barttitulaerexcelbart9400]

Hi Deborah, great tip. You can also use count and average. But watch out, I always show this to my students, the formula for Average is wrong, it should take the average of the blue cells, not the totals. If all the blue cells are filled, its ok, but if you delete some blue filled cells, you get the wrong answer...😉

[@contextures]

Thanks, Bart, and that's a great tip! - Debra

[@alisansar7738]

Thanks for your Good working, I have a query can you please help.
I want to view the sale of product like a tree type expend (year than expend months than show in date )

[@contextures]

Thanks, and in this video I show how to expand and collapse pivot table fields:
ruclips.net/video/SnmF1P_gQmM/видео.html