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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920