Hi Community,
I am using Excel 2010.
I have a problem with the formula below because it makes the workbook VERY slow:
I am trying to do a SUMIF in 80 worksheets (named range 'Tabs') and the structure of each of the 80 tabs is the same. B$2 in this case is 'Source 1' in the table below. I have a similar formula in each of the cells with '0'.
<tbody>
</tbody>
Is there any alternative to INDIRECT in this formula?
Thank you very much in advance.
Cheers,
Daniel
I am using Excel 2010.
I have a problem with the formula below because it makes the workbook VERY slow:
Code:
=IF(B$2="",0,SUMPRODUCT(SUMIF(INDIRECT("'"&Tabs&"'!B25:B245"),B$2,INDIRECT("'"&Tabs&"'!L25:L245"))))
I am trying to do a SUMIF in 80 worksheets (named range 'Tabs') and the structure of each of the 80 tabs is the same. B$2 in this case is 'Source 1' in the table below. I have a similar formula in each of the cells with '0'.
Source 1 | Source 2 | Source 3 | Source 4 | Source 5 | |
Refresher training & workshops | 0 | 0 | 0 | 0 | 0 |
Personnel | 0 | 0 | 0 | 0 | 0 |
Communications | 0 | 0 | 0 | 0 | 0 |
Maintenance | 0 | 0 | 0 | 0 | 0 |
Supplies, utilities & other recurrent cost | 0 | 0 | 0 | 0 | 0 |
Buildings | 0 | 0 | 0 | 0 | 0 |
Equipment | 0 | 0 | 0 | 0 | 0 |
Vehicles | 0 | 0 | 0 | 0 | 0 |
Consultants | 0 | 0 | 0 | 0 | 0 |
TOTAL | 0 | 0 | 0 | 0 | 0 |
<tbody>
</tbody>
Is there any alternative to INDIRECT in this formula?
Thank you very much in advance.
Cheers,
Daniel