Lets just say my Worksheet is 7 rows wide (a-d) and 5 rows long. In each row I have a total coming from data on a separate sheet. Column D is set up as a Total column for values in b-c. So it would look like:
1--A--B--C--D
2--1--2--3--6
3--5--2-1--8
4--3--2--1--6
5--1--1--2--4
My question is since my actual chart is much longer than 5 rows long is there any kind of formula or easier way to input the each sum formula at once or am I going to have to do each row one at a time?
Thanks!
1--A--B--C--D
2--1--2--3--6
3--5--2-1--8
4--3--2--1--6
5--1--1--2--4
My question is since my actual chart is much longer than 5 rows long is there any kind of formula or easier way to input the each sum formula at once or am I going to have to do each row one at a time?
Thanks!