Summing and count ?
 

How can I sum the last 3 columns or lines even if I add another line or column.

Wk 1 2
WK2 5
WK3 4
WK4 3
Total 12
Following week will be
WK1 2
WK2 5
WK3 4
WK4 3
WK5 2
Total 9

Assuming the total cell is in say A20


=SUM(OFFSET(A19,-2,0,3))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Victor" wrote in message
...
How can I sum the last 3 columns or lines even if I add another line or
column.

Wk 1 2
WK2 5
WK3 4
WK4 3
Total 12
Following week will be
WK1 2
WK2 5
WK3 4
WK4 3
WK5 2
Total 9