faster subtotals?

finnstone
finnstone used Ask the Experts™
on
is there a way to create faster subtotals in this book? i need to sum by column B
Book22.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial