| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to look at current date and markdown date to give price | Excel Discussion (Misc queries) | |||
| How can i give formula to count the only numbers except zero in a | Excel Discussion (Misc queries) | |||
| want a formula give total quanitity break up frm other sheet | Excel Worksheet Functions | |||
| can you count data in a cell to give a value? | Excel Worksheet Functions | |||
| Colomn of various dates, count & give % of all under 1 year, etc. | Excel Worksheet Functions | |||
Hybrid Mode
