| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumtotal as per date range
How to sum up the total of a particular column according to date range. For
example all data for the month of Jan 2006. Below is sample worksheet. A B C Date Item Amount 01/01/06 xxxxxxxx 100.00 01/08/06 yyyyyyyy 200.00 01/15/06 zzzzzzzz 150.00 01/22/06 mmmm 250.00 01/27/06 nnnnnnn 150.00 02/01/06 ddddddd 225.00 02/08/06 cccccccc 275.00 03/04/06 aaaaaaa 225.00 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding earliest date within a range by employee | Excel Worksheet Functions | |||
| Advanced filter a dynamic date range | Excel Worksheet Functions | |||
| Crate group of date, with Dynamic Range in pivot table not working | Excel Discussion (Misc queries) | |||
| Date Range within one cell | New Users to Excel | |||
| Date Range and calculation | Excel Worksheet Functions | |||
Threaded Mode
