| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2000 formula to dynamically sum adjacent rows and columnswhere rows inserted/deleted
For word wrap problem - Column A has the Client name and then it is
blank until a new Client name in Column A. In the example A1 = Client1, C1 = $400, D1 = $100, E1 = Employee1, A2 = the sum $2000, C2 = $500, D2 = blank, E2 = Employee2, etc. The client name is always in Column A with the sum immediately below it and the amounts are adjacent to A. Thanks for the suggestion about putting the client name in each row. The sheet is about 1000 rows with 100 different client names. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add cells on two adjacent rows but non-adjacent columns | Excel Worksheet Functions | |||
| How can I protect a sheet so the rows/columns can't be deleted? | Excel Worksheet Functions | |||
| Change colour of cells when content is altered/changed BUT NOT TO INSERTED OR DELETED ROWS | Excel Discussion (Misc queries) | |||
| Transpose: many columns to inserted rows | Excel Discussion (Misc queries) | |||
| If a Row is inserted or is a row is deleted then...... | Excel Worksheet Functions | |||
![sga[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
