Excel - How To Count How Many Of Each Value In Excel - Episode 1263

500 views · Published 11 October 2010 · 2:02 · Indexed 27 October 2026

Channel: MrExcel.com · 2010 · Education

Watch on YouTube

Microsoft Excel Tutorial: Counting Spreadsheet Entries: How to Count Entries in Excel using Pivot Tables | MrExcel Podcast.

Welcome to another episode of the MrExcel podcast. In today's episode, we will be discussing how to count entries in a spreadsheet. This is a common task that many Excel users encounter, and there are a few different ways to approach it. So, let's dive in and learn some new techniques!

First, we have a question from Ron who needs to count how many times each model appears in Column B of his data. One way to do this is by using the advanced filter and then a countif formula. However, my personal favorite method is by using a Pivot Table. It's quick, easy, and gives you a great snapshot of your data.

Before we can create the Pivot Table, we need to make sure our data is clean. This means getting rid of any unnecessary rows, such as the blank row 2 in Ron's data. Once that is done, we can insert a Pivot Table and drag the Model field to the Row Labels section. This will give us a list of each model and how many times it appears in the data. We can also add any other text field to the Values section to get a grand total.

One great thing about Pivot Tables is that they are live, meaning they will update as you add more data. However, if you want to use the data elsewhere and don't want it to be a Pivot Table anymore, you can simply copy and paste values. This will give you a simple report that you can use for other purposes.

I want to thank Ron for sending in this question and I hope this technique helps others who may have a similar task. As always, thank you for tuning in to the MrExcel podcast. Don't forget to drop me a note at [email protected] if you have a question for a future episode. 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) Count for each Model in this column
(00:23) Could use Advanced Filter, but today, a pivot table
(00:44) Add headings for your data
(01:00) Build the pivot table
(01:15) Getting a Count
(01:28) Convert to Values
(01:45) 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 #pivottable #pivot_table #excelpivot #excelpivottablestutorial 

This video answers these common search terms:
how to count how many of each value in excel
counting occurrences of each item in excel
how to find the count of distinct values in excel
count occurrences of each value in excel
calculating the frequency of data in excel
summarize data by counting values in excel
excel formula to count unique values
tallying data frequency in excel
excel function to count values
counting distinct items in excel

Ron asks how to count how many times each model occurs in a column. Today, in Episode #1263, use a Pivot Table to quickly solve the problem and display results.

Join the MrExcel Message Board discussion about this video: https://www.mrexcel.com/board/threads/counting-spreadsheet-entries-podcast-1263.1152944/

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

More from this channel