Summing and count ?

[Guest]

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

 

[Bob Phillips]

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)