Sum Product Function gives erros message "Excel ran out of resources while attemtng to calculate onr or more formulas. As a result, these formulas can

[harrymarfatia7]

Hello Excel Group Members,

I am trying to create sumproduct function in cell C17, but it gives me this error message.

Formula = SUMPRODUCT((sum_dollar)*(capex_propex_range=$B$16)*((actual_forecast_range=C$15)*(sum_date_range=C$16)*(SPENDTYPE_RANGE=$B17)))

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

I have used the similar formula in cell C11, and it works OK there.

Formula = SUMPRODUCT((sum_dollar)*(capex_propex_range=$B11)*((actual_forecast_range=C$9)*(sum_date_range=C$10)))

Can anyone please help?

I have attached spreadsheet for your review.

Thanks.

Harry.

 

[RoryA]

How big are the ranges, especially the SPENDTYPE_RANGE?