Excel - Discover the Unconventional Read Aloud Method for Adding Numbers in Excel - Episode 1427

856 views · Published 15 September 2011 · 2:54 · Indexed 16 November 2026

Channel: MrExcel.com · 2011 · Education

Watch on YouTube

Microsoft Excel Tutorial: Discover the Unconventional Read Aloud Method for Adding Numbers in Excel.

Welcome to the MrExcel podcast. In this episode, #1427, we will be discussing the read aloud method in Excel. As many of you know, I recently released a new book called "Don't Fear The Spreadsheet" for those who are new to Excel. And let me tell you, the response has been amazing. I've received some great stories from readers, and today I want to share one of them with you.

This story comes from a man named K, who works in IT support. He received a call from a new contractor who was struggling with VLOOKUP. K went over to help and quickly realized that the issue was not just with VLOOKUP, but with the contractor's method of adding up numbers. She would select the cells and then use the read aloud method to add them up. This involved saying the numbers out loud and then typing them in. K was amazed by this method and decided to share it with us.

Now, I know what you're thinking - why not just use the SUM formula? Well, K tried to show her this, but she couldn't quite get the hang of it and went back to her read aloud method. This got me thinking, how many other people out there are using unconventional methods in Excel? According to statistics, there are 750 million Excel users and 40% of them have never entered a formula. That's a lot of potential for unique methods like the read aloud method.

So, I want to hear from you. Have you ever come across a co-worker who has a unique way of using Excel? Maybe they have their own version of the read aloud method. Share your stories with me at [email protected] and you could be featured in an upcoming episode. And if your story beats K's, I'll even send you a copy of my book "Don't Fear The Spreadsheet" to share with your co-worker.

I hope you enjoyed this episode and learned something new about Excel. Don't forget to subscribe to our channel for more helpful tips and tricks. Thanks for watching and I'll see you in the next netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) The Read Aloud Method for Copying Totals
(00:20) Stories from new Excel users
(01:00) Explanation of the method
(01:31) Half the time, the numbers were transposed
(01:47) Introduction to the SUM formula
(02:01) Woman's reaction to the formula
(02:11) Encouraging viewers to share their own stories
(02:44) Clicking Like really helps the algorithm

This video answers these common search terms:
=SUM formula
Adding up numbers in Excel
Don't Fear The Spreadsheet
Episode 1427
Excel for beginners
Funny Excel stories
IT support
Learn Excel
MrExcel podcast
Read aloud method
VLOOKUP


Today, in Episode #1427, Bill shares an interesting way to find totals in Excel ... the Read Aloud Method! This episode is another in our series for Don't Fear the Spreadsheet. Send in your best Excel Newbie stories! Learn Excel from MrExcel!

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153105/

More from this channel