Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() This is the perfect application for a pivot table. Put meaningful names in the row above your first row of data. Month, Account, Money might be correct in this example. In Excel turn on the pivot table toolbar view -toolbar- PivotTable Activate the pivot table wizard, and it will walk you through the process. Step 1. Indicate list. Step 2. When you are asked for a range, specify the labels as well as the data. Step 3. Select new worksheet, and click layout. Drag month and account to the row or column as desired. drag money to the Data ares, it should say "sum of Money. click ok click finish This should be what you want. -- LarryLL ------------------------------------------------------------------------ LarryLL's Profile: http://www.excelforum.com/member.php...o&userid=36136 View this thread: http://www.excelforum.com/showthread...hreadid=559379 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DAVERAGE criteria HELP!!!! | Excel Discussion (Misc queries) | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Select rows of data in a worksheet on one criteria in multiple co | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |