Hello,
having issues figuring out how to sum a range from a table in a different workbook. I need to sum the AR part but the number of rows will vary from file to file so cannot just put SUM(B1:B2) ..I need to specify B2 dynamically because that one will change (B1 will not)
<tbody>
</tbody>
If INDIRECT was working from closed files it would be no problem but it's not. Any ideas?
Thanks
having issues figuring out how to sum a range from a table in a different workbook. I need to sum the AR part but the number of rows will vary from file to file so cannot just put SUM(B1:B2) ..I need to specify B2 dynamically because that one will change (B1 will not)
AR | 100 |
200 | |
AP | 10 |
20 |
<tbody>
</tbody>
If INDIRECT was working from closed files it would be no problem but it's not. Any ideas?
Thanks