We help IT Professionals succeed at work.

faster subtotals?

is there a way to create faster subtotals in this book? i need to sum by column B
Book22.xlsx
Comment
Watch Question

Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
I have inserted a new row and placed two headers called Item and Value then inserted a Pivot Table and dragged the Item field into the Row area and Value field into the Values area.
The pivot table will show you the count of each item first as there are blanks in the data set. To show the Sum, right click on any cell in the count of values column and choose SUM from Summarize Values By option.
Book22.xlsx

Author

Commented:
thx!
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome!