Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Summing (Sumif? Countif?) | Excel Worksheet Functions | |||
SUMMING COLUMNS IN DIFFERENT WORKSHEETS | Excel Discussion (Misc queries) | |||
Counting and Summing | Excel Discussion (Misc queries) | |||
Summing 2 columns | Excel Worksheet Functions | |||
Independently Summing Multiple Text Options Within a Cell | Excel Worksheet Functions |