Forum Discussion
Large Workbook Calculations
I have a question about equations using a large amount of data in a workbook (containing over 100 spreadsheets). Basically I have wage data for over 100 different agencies (each with it's own spreads...
It very depends on which Excel version platform you are. Technique you use was practically the only one for Excel which doesn't support dynamic arrays.
If you are on Excel 365 follow Patrick2788 suggestion. In particular, instead of first part of your formula
SUMPRODUCT(SUMIF(INDIRECT("'"&$A$110:$A$273&"'!G1"),"Belknap",INDIRECT("'"&$A$110:$A$273&"'!J3")))that could be something like
=SUM( ( HSTACK(FirstSheet:LastSheet!G1)="Belknap" )*HSTACK(FirstSheet:LastSheet!J3) )