Excel - Count Between Ranges II: Episode 1511

1,965 views · Published 24 January 2012 · 2:14 · Indexed 25 October 2026

Channel: MrExcel.com · 2012 · Education

Watch on YouTube

Microsoft Excel Tutorial: Counting Between Ranges in Excel Using PivotTable | MrExcel Podcast.

Welcome to the MrExcel Podcast. In this episode, we will be discussing how to count between ranges in Excel. This is a common question that many Excel users have, and we will be exploring a faster and more efficient way to achieve this task.

In our previous episode, we discussed how to count values between 10 and 20. However, upon further consideration, it seems that the real goal is to count between all ranges, not just one specific range. This can be achieved using the Insert, PivotTable feature in Excel.

To begin, we will create a pivot table on a new worksheet. Then, we will take the Value field and place it in both the Row Labels and Values sections. Next, we will change the field settings to Count, so we can see how many times each record appears. This may seem uninteresting at first, as each value will likely appear only once. However, the real magic happens when we use the Group Field feature.

By grouping the values in increments of 10, we can quickly see the count for each range. This eliminates the need for complicated formulas and allows us to easily see the count for all ranges. Additionally, we can customize the appearance of the pivot table by changing the layout and renaming the fields.

Thank you for tuning in to this episode of the MrExcel Podcast. I hope you found this tip helpful and will join us for future episodes. Don't forget to like, comment, and subscribe for more Excel tips and tricks. See you next time!

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) Counting Between Ranges
(00:20) Using PivotTable for Faster Solution
(00:47) Adjusting PivotTable Settings
(01:05) Grouping Data in PivotTable
(01:26) Formatting PivotTable
(01:43) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Count between ranges
Counting records
Creating pivot table
Episode 1509
Excel formulas
Formatting pivot table
Grouping data
Insert PivotTable


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


Today, in Episode #1511, Bill reviews Counting Between Ranges using a Pivot Table solution.
Due to a slight mix up, the follow-up to Learn Excel from MrExcel Podcast #1508 is airing today - an episode nearly slated for the 'Lost Episode' vault!

...This episode is the video podcast companion to the book, "Learn Excel 2007 through Excel 2010 from MrExcel". Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book!

"The Learn Excel from MrExcel Podcast Series"

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

More from this channel