very clever response, and it worked perfectly thank you very much.

"Don Guillett" wrote:

Perhaps you would strongly agree to lower your number from 61523 unless that
is the bottom of your data

--
Don Guillett
SalesAid Software

"Scott@CW" wrote in message
...
I am using a workbook that has two sheets. One is a data sheet the other is
a
reporting template. On the reporting template sheet I am using about 25
sumproduct functions like the one below. This seems to take some time to
calculate. Is there a faster way of running these formulas. I know the
issue
is not the PC.

=SUMPRODUCT(--(DATA!$B$2:$B$61523=$C$5),--(DATA!$C$2:$C$61523=$C$6),--(DATA!$D$2:$D$61523="Strongly
Agree"))