Hi guys - a dynamic sum question for you.
I have a table spreadsheet with inventory in Column A, and month columns with inventory on hand/credit/sold for each subsequent month.
I'm looking for a formula that will calculate the year to date credit.(essentially the simple formula for the credit amount on shoes in the HTML below would be D4+G4+J4+M4....)
However, the spreadsheet contained here has been simplified - the real sheet contains dates before Jan 02 and carries dates out until Jan 04, as well as additional columns in between each date.
As of now, I do the simple formula D4+G4+J4+M4... and have to update it every month.
Any advice welcome,
Renee
This message was edited by Rpan on 2002-09-10 19:45
I have a table spreadsheet with inventory in Column A, and month columns with inventory on hand/credit/sold for each subsequent month.
I'm looking for a formula that will calculate the year to date credit.(essentially the simple formula for the credit amount on shoes in the HTML below would be D4+G4+J4+M4....)
However, the spreadsheet contained here has been simplified - the real sheet contains dates before Jan 02 and carries dates out until Jan 04, as well as additional columns in between each date.
As of now, I do the simple formula D4+G4+J4+M4... and have to update it every month.
Any advice welcome,
Renee
Book2 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
1 | Inventory | ||||||||||||||||
2 | |||||||||||||||||
3 | Jan-02 | credit | Sold | Feb-02 | credit | Sold | Mar-02 | credit | Sold | Apr-02 | credit | Sold | .. | ||||
4 | Shoes | 50 | 3 | 5 | 45 | 5 | 5 | 40 | 1 | 6 | 34 | 5 | 3 | ||||
5 | Pants | 100 | 4 | 15 | 85 | 2 | 10 | 75 | 2 | 15 | 60 | 4 | 12 | ||||
6 | Shirts | 20 | 5 | 2 | 18 | 6 | 5 | 13 | 3 | 5 | 8 | 2 | 3 | ||||
7 | Jackets | 30 | 6 | 3 | 27 | 8 | 3 | 24 | 4 | 8 | 16 | 10 | 6 | ||||
8 | Socks | 100 | 4 | 25 | 75 | 5 | 15 | 60 | 8 | 15 | 45 | 5 | 10 | ||||
9 | |||||||||||||||||
10 | |||||||||||||||||
Sheet1 |
This message was edited by Rpan on 2002-09-10 19:45