sum formula with overlaping references

R

RBall

B C D E F G H I J
K L M N

LAST

SIX
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV
DEC MON
1.2 1.0 2.3 1.6 2.0 1.8 5.1 3.2 1.5 .8
?

? is where I need a formula (row 3). Can someone help, before I pull the
rest of my hair out? What I am trying to accomplish is the calculation of the
the last six months. As you can see in the example above for the month of
October there is .8 already for the month. Now I need the worksheet to
automatically calculate the last six months which should total 14.4. Now if
we go back in time to August it should calculate the last six months which
would be 16. Hopefuly this explains it o.k., but if not let me know & try to
provide some more information. Thanks in advance!!!!
 
R

RBall

Hopefully this works. If not B-N is one row(1), Jan-Last Six Months is one
row(2) and 1.2-? is one row(3).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Formula of IF/AND/COUNT/SUM 0
Allocation/Distributiona Formula... 0
help with formula to calculate what column to use 2
NEED FORMULA TO PICK UP TOP OF A COLUMN WHEN CERTAIN CRITERIA MET 3
create a formula to know last months column character or number 0
Formula to fill cells based on Date of Arrival and Date of Departure 1
Average/Sum formula with offset 9
Search Columns for a word and stop 14

Top