Group by Sales Range in Excel Pivot Tables

Don’t forget to download the Exercise Workbook below and follow along with us:

Here is our data table:

STEP 1: Let us start with an empty Pivot Table. Drag Sales to Rows

STEP 2: Right-click on any Sales value and select Group

STEP 3: Let us set our group range to 10,000-100,000 with the groupings by 10,000. Click OK.

STEP 4: Now drag Sales to Values twice

STEP 5: We will get 2 similar columns. We want to have them show the Sum and Count.

Select any one of the columns and pick Value Field Settings

STEP 6: Select Sum and click OK

Now you are able to gather data based on the grouped sales figures!

You can use this method to group Pivot Table data by sales range, age, price range or any other numerical data!

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.