Forum Discussion
Solved
Running Comparison
I would like to maintain a running comparison of values from year to year. I would like to do so in the following fashion: 1 3 5 7 10 15 5 8 2 5 61 (26 after the same numb...
*
Robert V Giancarlo wrote:I have string values in the A column on my sheet identifying what each row is and my data values begin with the B column thru M column
That is important information. The formula has to reflect this:
=SUM(B7:INDEX(7:7,COUNT(B7:M7)+1))-SUM(B6:INDEX(6:6,COUNT(B7:M7)+1))
So it does sir, when I try it on a new sheet and from the A column.
I have string values in the A column on my sheet identifying what each row is and my data values begin with the B column thru M column but I am getting an error when I input the formula. Also after entering the second value (using rows 6 and 7 and columns B through M for data) in C7 the formula does not update. After entering the subsequent value at D7 the formula updates to the result I should have obtained after C7.
I am editing my sheet as shown below.
=SUM(B7:INDEX(7:7,COUNT(B7:M7)))-SUM(B6:INDEX(6:6,COUNT(B7:M7)))
How do I correct this?
Robert
*
Robert V Giancarlo wrote:I have string values in the A column on my sheet identifying what each row is and my data values begin with the B column thru M column
That is important information. The formula has to reflect this:
=SUM(B7:INDEX(7:7,COUNT(B7:M7)+1))-SUM(B6:INDEX(6:6,COUNT(B7:M7)+1))
Sir, that looks like exactly what I am looking for. Thank you very much for your time and assistance.
Robert
