|
|
#2
03-05-2019, 03:14 PM
|
||||
|
||||
you could try something along the lines of:
=SUM(INDEX($D$3:$Z$5,0,ROW()-13)) but the 13 in there is because the topmost cell my formula was in was on row 14. You need to adjust the 13 to the row the topmost formula is in minus 1, then copy down. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Dragging a row changes formatting | BertLady | Word Tables | 1 | 12-01-2018 11:44 PM |
 Dragging conditional formatting like a formula
|
sjp1966 | Excel | 9 | 04-13-2017 06:01 AM |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
|
Dragging cells with filters on
|
krisjah | Excel | 1 | 01-25-2014 11:08 AM |
|
Dragging Pictures into Placeholders
|
simville02 | Drawing and Graphics | 1 | 09-29-2013 06:33 PM |
Windows 10 
Office 2016
Threaded Mode