Excel Resources limitation

I am trying to process some data output from some CAD files, basically areas divided into separate categories (layers).

I'm using an array formula that is pretty simple {=sum((A)*(B)*(C))}

Sheet 1 contains a formula that reads about 300 rows and 3 columns of data in Sheet 2 and evaluates the following
A = 'Sheet2'!$A:$A=F$2 (Sheet1 column header value)
B = 'Sheet2'!$B:$B=$A4 (Sheet 1 row header value)
C = 'Sheet2'!$C:$C (The area value from sheet 2)

If condition A or B is false the value to be summarized is 0, if both A+B are true the value of column C is summarized.

It has worked fine on other worksheets but today I get the following error message:

Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated.

I've tried closing Excel, shutting down my computer, etc and nothing seems to clear the error. My system is fairly robust Intel I7-3770K@3.5GHz 32GB Ram, 1.6 TB free space.

I know arrays are processor intensive but this doesn't seem too difficult. Does any one have insight to Excel's limits and potentially another workaround?

Thanks,

Tmo

Limit the ranges to what you need, using either fixed ...

=sumproduct(A1:A100, B1:B100, C1:C100)

... or dynamic ranges: http://exceluser.com/formulas/dynname1.htm

You're welcome.