Hello,
I have the following formula and needless to say, the calculation is very slow.

=SUMPRODUCT(--('85_08'!$A$2:$A$10800='09 YTD Auto Claims'!G38),--('85_08'!$B$2:$B$10800="A"))

Right now this formula is copied down about 4,000 rows and this will grow in double the rows by the end of the year. Plus another column which is looking for the same criteria only instead of A, it will be an I. I would greatly appreciate any help or advice in making this formula better and faster.
Thanks
Michelle