Hello,

I am using Named Ranges in my primary worksheet, and referencing them
with about 10,000 SUMPRODUCT formulas in another worksheet. When I add rows
of data to the primary worksheet, the secondary worksheet is running all
10,000 formulas to see which cells should be populated.
The SUMPRODUCT formulas all reference the "Application" and "Date"
columns as the two criteria. Is there a way to make the secondary worksheet
only run the formulas for the current date, like a GetDate() statement in SQL
would do? That would greatly improve my performance because only 25 formulas
would be running instead of 10,000, when I add a row of data. If I wasn't
clear on my scenario, please ask and I will be glad to clarify. Thanks for
any help that anyone can provide.

John