Adding rows in two dynamic columns

J

Justin Etheredge

I have two columns in a table that are imported from another table, and
then I have specified dynamic data ranges for them using
Insert..Name...Define and I use OFFSET and COUNTA to select these ranges.
What I need to know is....If I need to SUM each row of the two columns
together, how do I get the SUM column to extend when I add more data to the
other two columns? I have the sum of the two columns using this formula

=SUM(INDEX(SUMDataCLA,ROW(), 1), INDEX(SUMDataCLU, ROW(), 1))

and then I use the FILL DOWN to fill it to the end of the columns, but when
I add more data, I have to use the FILL DOWN again to extend the SUM
formula down. I hope this question is clear!

Thanks,
Justin Etheredge
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
MS Project Center-Autolink column fields 0
Multiple IF Statement in Word 5
Sum every Nth Row (almost working) 2
Sum Values from different column 1
Dealing with a Pivot Table (when I don't want to) 0
sum of multiple rows 2
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 3

Top