Hi I have a sheet, currently say with values in A1, A2, A3 and A4
In cell A5 i want to sum the values of A2+A4 (I know i can simply type =A2+A4 but my problem isn't that simple, this is just a scenario for ease of explanation), possibly using the MOD function? Something like where MOD(COLUMNS($A$2,A4)/2)=0 ?
I also want my sum value to update, say if someone inserted two columns, A5 and A6, meaning my sum calculation moved to A7, but calculated A2+A4+A6
Does that make any sense to anyone?
All help gratefully received
In cell A5 i want to sum the values of A2+A4 (I know i can simply type =A2+A4 but my problem isn't that simple, this is just a scenario for ease of explanation), possibly using the MOD function? Something like where MOD(COLUMNS($A$2,A4)/2)=0 ?
I also want my sum value to update, say if someone inserted two columns, A5 and A6, meaning my sum calculation moved to A7, but calculated A2+A4+A6
Does that make any sense to anyone?
All help gratefully received