Thread: Subtotals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stan Stan is offline
external usenet poster
 
Posts: 150
Default Subtotals

I have 2 columns of data that I need subtotals on both.

Group Start Time
7750 8:00 am
7750 8:00 am
7750 8:30 am
7750 8:30 am
7750 8:30 am
7751 7:30 am
7751 7:30 am
7751 8:30 am

In the above example I would like the outcome to be:

Group Start Time Count
7750 8:00 am 2
7750 8:30 am 3
7751 7:30 am 2
7751 8:30 am 1

Of course I can subtotal either column but I'm not sure how I can subtotal
them together to achieve the desired outcome. My goal is to run a macro that
would do this for me all at once.

Any help you can provide would be much appreciated!

Many thanks!