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: