This is my issue:

Excel 2007:
Formula in question:
=SUMPRODUCT((Unique!$E:$E=C$2)*(Unique!$E:$E<D$2) *(Unique!$J:$J=$A3)*(Unique!$G:$G="Closed"))

or

{=SUM((Unique!$E:$E=C$2)*(Unique!$E:$E<D$2)*(Uniq ue!$J:$J=$A3)*(Unique!$G:$G="Closed"))}

Scenario: I have somewhere around 100 similar formulas traversing about 60K
unique values. When I hit calculate my AMD 64 x2 Processor hits 100% on both
processors making the machine virtually unusable until the calculation
completes. Is there a more efficient way to get at my data? Is there a more
efficient formula that I could/should be using?

Please let me know if you need more specifics about the data, but it's
really a basic count of instances of entries with conditions to be satisfied
in order to be counted.

TIA

Cheers!