Thread
: [Solved]
How to optimize the data summation code for each row and column in a data rectangle area?
View Single Post
10-04-2020, 03:08 AM
Purfleet
Windows 10
Office 2019
Expert
Join Date: Jun 2020
Location: Essex
Posts: 345
Run it and you will see that in a15 to j15 each column is now a sum of 1:14 as we have not put the $ the ranges are not locked so the columns are relative
The same for the rows
if you want to sum the corner you can just do range(k15) = Sum(a1:j14)
Purfleet
View Public Profile
Find all posts by Purfleet