Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-11-2014, 07:27 AM
bluionz bluionz is offline Indirect Formula with dynamic rows Windows 7 64bit Indirect Formula with dynamic rows Office 2013
Novice
Indirect Formula with dynamic rows
 
Join Date: Mar 2014
Posts: 1
bluionz is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 03-13-2014, 11:00 AM
gebobs gebobs is offline Indirect Formula with dynamic rows Windows 7 64bit Indirect Formula with dynamic rows Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Can you attach a sheet?
Reply With Quote
Reply

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
Indirect Formula with dynamic rows 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
Indirect Formula with dynamic rows Data validation using indirect function BullMouse Excel 2 11-30-2011 05:25 PM
Indirect zleyphox Excel 1 02-11-2010 09:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft