#1
|
|||
|
|||
Indirect Formula with dynamic rows
Hello All-
I apologize if this has been asked before, but I've been unable to locate an understandable answer. I'm attempting to use the SUM function on an indirect range so that I can insert columns with current dates, but I need to have the columns be dynamic for alphabetization purposes in our vertical. I've tried using $, but I have been unsuccessful thus far. Here's what I have been using: =SUM(INDIRECT("B2"):INDIRECT("F2")) This formula works to calculate the data I need, but I need to be able to pull it down to fill any cells that are not filled as rows get added. The formula also needs to be able to adapt to when I am adding rows above it. Any ideas? Any help would be greatly appreciated. |
#2
|
|||
|
|||
Can you attach a sheet?
|
Tags |
dynamic, formulas, indirect |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula that can merge multiple rows with the same ID into one row | Hilwey | Excel | 3 | 07-08-2015 08:50 PM |
Grouping table rows to prevent individual rows from breaking across pages | dennist77 | Word | 1 | 10-29-2013 11:39 PM |
Filter indirect dependencies | SirPercival | Project | 1 | 07-04-2012 01:03 PM |
Data validation using indirect function | BullMouse | Excel | 2 | 11-30-2011 05:25 PM |
Indirect | zleyphox | Excel | 1 | 02-11-2010 09:57 AM |