Summarizing data from a Column

Originally Posted by MarvinP

Hi lps.

If you click anywhere in your column and then on the Insert Tab and then on "Pivot Table" you will get a dialog. Click ok and then drag "Activity Type" to Rows and also to Values.
This will give you exactly what you want.

If you attach your sample workbook, we can do it for you also. It is really about a 5 second problem, if you use Pivot Tables. No formulas or VBA needed.

Worked greatly. Thank you!!