HOW TO ADD 2D NAMED RANGES WITH SAME DIMENSIONS?

[ytjjjtyj]

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]

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]

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]

6 methods (4 macros and 2 formuale) in the attached.

[ytjjjtyj]

p45cal, I cannot thank you enough. I am crying thank you so so much- you are amazing and this was exactly what I needed.