subtotals that break on date & give count & sum ($$ col)
 

I have a worksheet that is sorted on date column. I want to subtotals when
ever the date changes of count of dates and sum of amount column. I can get
the count to work but I can't seem to find how to add the amount subtotal on
the same row as the count subtotals.

subtotals that break on date & give count & sum ($$ col)
 

Hi,

Create a pivot table. Drag date to the row area. Drag amount to the data
area and drag date once again the data area.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"PurpleTeri" wrote in message
...
I have a worksheet that is sorted on date column. I want to subtotals
when
ever the date changes of count of dates and sum of amount column. I can
get
the count to work but I can't seem to find how to add the amount subtotal
on
the same row as the count subtotals.