| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summing column and rows
Hello Excel users and Experts,
=C1+INDIRECT(CHAR(ROW()+67)&1) With this formula in B1 and pulled down will add C1 & D1, C2 & E1, C3 & F1 etc. How can I make INDIRECT(CHAR(ROW()+67)&1) reference sheet 2 with C1, C2, C3 on sheet 1? So it sums C1 of sheet 1 and D1 of sheet 2 C2 of sheet 1 and E1 of sheet 2 and so on. Thanks for any ideas. Regards, Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
| Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
| Summing rows based on column headings | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Threaded Mode
