Hi
I have one very large range of data and another of the same size. I need to add the corresponding cells in each range to create another range of the same size with the sum of the corresponding cells.
I am currently using a simple SUM(A1, A10000) function. In terms of the speed and size of the file is it better to use =A1+A10000.
thanks
I have one very large range of data and another of the same size. I need to add the corresponding cells in each range to create another range of the same size with the sum of the corresponding cells.
I am currently using a simple SUM(A1, A10000) function. In terms of the speed and size of the file is it better to use =A1+A10000.
thanks