Hi All,
Just trying to get a formula in workbook A to get Month to date figures from the data below in workbook B, say I need to get the Apple figure up to May, so in workbook A i had May in the title cell A1 but in A2 i should use the formula to get the sum of $26. I tried sum(if but this can only add one column rather than multiple columns, also tried sum(offset but this does not work with the data in a different workbook data and lastly tried to concatenate sum formula from Range Column A to Nth Column dependence on the month but cannot get the sting into a formula even using indirect. Any better suggestion would be much appreciated. thanks for your help. Cheers, Peter
<tbody>
</tbody>
Just trying to get a formula in workbook A to get Month to date figures from the data below in workbook B, say I need to get the Apple figure up to May, so in workbook A i had May in the title cell A1 but in A2 i should use the formula to get the sum of $26. I tried sum(if but this can only add one column rather than multiple columns, also tried sum(offset but this does not work with the data in a different workbook data and lastly tried to concatenate sum formula from Range Column A to Nth Column dependence on the month but cannot get the sting into a formula even using indirect. Any better suggestion would be much appreciated. thanks for your help. Cheers, Peter
A | B | C | D | E | F | G | H | I | J | K | L | M | |
1 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
2 | Apple | 7 | 1 | 2 | 10 | 6 | 6 | 10 | 6 | 2 | 1 | 9 | 10 |
3 | Orange | 2 | 9 | 4 | 2 | 8 | 8 | 10 | 3 | 2 | 2 | 4 | 8 |
4 | Mango | 6 | 2 | 6 | 5 | 3 | 0 | 5 | 2 | 7 | 5 | 9 | 6 |
<tbody>
</tbody>
Last edited: