I know my above question is really beginner level question to foswiki gurus, especially while their agendas is full of developing tasks&issues. But for now, this is my question and still needs your support.

Here is a bit of a tutorial starting with how to reference an individual cell, and how to do calculations, finishing with a couple of columns from your example:

Reference to a single cell is done with $T(Rn:Cn) So this example uses %CALC{"$T(R1:C1)"}% to access Row 1 Column 1.

25

%CALC{"$T(R1:C1)"}%

25

25

However to be flexible, you might want to reference columns in "this row", without having to enter an explicit row number. $ROW() returns the absolute row number, so replace the row number with R$ROW() to reference to cells in "this" row. This example uses %CALC{"$T(R$ROW():C1)"}%

25

%CALC{"$T(R$ROW():C1)"}%

25

25

To make calculations, you use the $EVAL() function. For example, to multiple Column 1 times 2: