PDA

View Full Version : [SOLVED] HOW TO ADD 2D NAMED RANGES WITH SAME DIMENSIONS?



ytjjjtyj
07-11-2019, 03:42 AM
Hello, I have MULTIPLE named ranges with the same dimensions: 100 rows, 200 columns.
I want to add all the named ranges together to one range. How do I do that?
I have attached a easier version of what I am trying to do below- it is a subroutine.

Also, if there is a better way to code it or make it look better please let me know.


24573

Jan Karel Pieterse
07-11-2019, 08:20 AM
What do you want to achieve precisely?
Add the values of all the cells of all the named ranges? =SUM(rng1_,rng2_,rng3_)
Or add the value of each individual cell of each individual named range? SUM(D2,G5,H2), SUM(E2,H5,I2), ....

ytjjjtyj
07-11-2019, 08:34 AM
Hello,
I want to add each individual same cell location's value of each individual named range and put the sum of all of them into a range named SumOfNamedRanges.

p45cal
07-11-2019, 10:26 AM
6 methods (4 macros and 2 formuale) in the attached.

ytjjjtyj
07-12-2019, 06:09 AM
p45cal, I cannot thank you enough. I am crying thank you so so much- you are amazing and this was exactly what I needed.