At someone's suggestion earlier today, I created a table with a dynamic range name. My question now is how to use the table's column headers in a SUMIFS function. I have attached a file showing what I am doing. Currently, each column header is a separate array, which take time to adjust when I update the database. I would like to simply be able to expand and contract the table in one operation.
I'd recommend making it an actual table.
Right now you just have data in neat little rows, but's not really a 'table' unless you highlight the data and go to Insert -> Table.
Once the ranges are defined by the length of the table, the named ranges will update themselves as the tables grows or shrinks.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Thank you very much for replying. I will look into what you've said.
hi cmcgath, would that help? The data table is converted to a table and referenced in the formulas accordingly.
I will have to look at your proposed solution carefully. Thanks for replying.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks