From the course: Excel VBA: Process Modeling
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Summarize results using the Total row
From the course: Excel VBA: Process Modeling
Summarize results using the Total row
- [Instructor] Excel tables are useful and versatile tools. It's a shame more users aren't aware of them. One of the elements of Excel tables that I use a lot, is the Total Row. You can add a Total Row to your table and use it to summarize values in a column. That could be finding the sum of all processing times or the average of customer idle time. In this movie, I will show you how to add the Total Row and change how it summarizes your table data. My sample file is Chapter07_03, and you can find it in the Chapter07 folder of your Exercise Files collection. I have already run the simulation, so I will switch to the Results worksheet. To display the Total Row, make sure that a cell within the body of the Excel table is the active cell. Then, go up to the Table Design contextual tab of the ribbon, and in the Table Style Options group, check the Total Row box. You can see that at the bottom of the table, we now have a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.