Forum Discussion

Copper Contributor

May 12, 2018

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...

excel

Detlef_Lewin
May 14, 2018
*
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))

Robert V Giancarlo

Copper Contributor

May 13, 2018

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

Detlef_Lewin

Silver Contributor

May 14, 2018

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))

Robert V Giancarlo
Copper Contributor
May 14, 2018
Sir, that looks like exactly what I am looking for. Thank you very much for your time and assistance.

Robert