Forum Discussion
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))
do you want it on every column or just that particular column?
