Bypass Excel 32BIT processing limit of 2GB

Hello all. I have run into a problem with what I now know is the Excel 32BIT processing limit of 2GB. I have been working on a workbook with the help of many here in the Forum and now the various formulas and VBA in addition to the enormous amount of data being processed kills the processing when any of my computers reaches just under 2GB Excel RAM usage as shown by Task Manager. I downloaded a trial version of Office 2010 64BIT and file processed fine (used over 5GB of RAM). The problem began when I started using

=SUMPRODUCT(SUMIFS(F:F,A:A,"543233"))

which is applied to 24 columns on every sheet created. Until then everything worked fine. The attached sample works of course because it has almost no data to process. As the VBA works now, a new sheet is created for each customer found, the customer data is copied to the customer sheet where a combination of VBA and formulas format the data, then the process is repeated for over 500 customers and over 40,000 total rows of data. I am not good with either VBA or formulas so don't know if there is a more efficient method of getting the results the example provides. Thanks in advance.