Using SUMPRODUCT with arrays
 

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

Using SUMPRODUCT with arrays
 

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

Using SUMPRODUCT with arrays
 

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

Using SUMPRODUCT with arrays
 

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

--
Don Guillett
SalesAid Software

"Scott@CW" wrote in message
...
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"))