Using SUMPRODUCT with arrays

[Guest]

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"))

 

[Don Guillett]

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

 

[Guest]

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

 

[Don Guillett]

Glad it helped. You may want to define a name for the ranges to auto adjust
to additions/deletions
edit>name>define>colB>in the refers to box type>
=offset($b$2,0,0,counta($b:$b)-1,1)