I have a long equation which I need to repeat 16 times!

try
=SUMPRODUCT(--(and(mod(column($A$5:$AT$555),3)=1,'Data
Source'!$A$5:$AT$555=$A$4),--('Data
> Source'!$C$5:$AV$555=$D$3),'Data Source'!$B$5:$AU$555)


"CC-Khriz" wrote:

> I have a long equation which I need to repeat 16 times!
>
> 3 columns per month plus 4 additional sets of 3
> EG:
> A1 B1 C1 D1 E1 F1 G1
>
> Jan Feb ect
> Acct Value Ter Acct Value Ter
> 221sds21 $233 4 221sds21 $233 4
>
> The equation I have for the 1st set of 3 columns is:
>
> =SUMPRODUCT(--('Data Source'!$A$5:$A$555=$A4),--('Data
> Source'!$C$5:$C$555=D$3),'Data Source'!$B$5:$B$555)
>
> is there a shorter way to sum the 16 x3 columns without repeating the same
> equation in multiple columns then adding the values?
>
> Many thks in advs Chris

try
=SUMPRODUCT(--(and(mod(column($A$5:$AT$555),3)=1,'Data
Source'!$A$5:$AT$555=$A$4),--('Data
> Source'!$C$5:$AV$555=$D$3),'Data Source'!$B$5:$AU$555)


"CC-Khriz" wrote:

> I have a long equation which I need to repeat 16 times!
>
> 3 columns per month plus 4 additional sets of 3
> EG:
> A1 B1 C1 D1 E1 F1 G1
>
> Jan Feb ect
> Acct Value Ter Acct Value Ter
> 221sds21 $233 4 221sds21 $233 4
>
> The equation I have for the 1st set of 3 columns is:
>
> =SUMPRODUCT(--('Data Source'!$A$5:$A$555=$A4),--('Data
> Source'!$C$5:$C$555=D$3),'Data Source'!$B$5:$B$555)
>
> is there a shorter way to sum the 16 x3 columns without repeating the same
> equation in multiple columns then adding the values?
>
> Many thks in advs Chris

I have a long equation which I need to repeat 16 times!

3 columns per month plus 4 additional sets of 3
EG:
A1 B1 C1 D1 E1 F1 G1

Jan Feb ect
Acct Value Ter Acct Value Ter
221sds21 $233 4 221sds21 $233 4

The equation I have for the 1st set of 3 columns is:

=SUMPRODUCT(--('Data Source'!$A$5:$A$555=$A4),--('Data
Source'!$C$5:$C$555=D$3),'Data Source'!$B$5:$B$555)

is there a shorter way to sum the 16 x3 columns without repeating the same
equation in multiple columns then adding the values?

Many thks in advs Chris

try
=SUMPRODUCT(--(and(mod(column($A$5:$AT$555),3)=1,'Data
Source'!$A$5:$AT$555=$A$4),--('Data
> Source'!$C$5:$AV$555=$D$3),'Data Source'!$B$5:$AU$555)


"CC-Khriz" wrote:

> I have a long equation which I need to repeat 16 times!
>
> 3 columns per month plus 4 additional sets of 3
> EG:
> A1 B1 C1 D1 E1 F1 G1
>
> Jan Feb ect
> Acct Value Ter Acct Value Ter
> 221sds21 $233 4 221sds21 $233 4
>
> The equation I have for the 1st set of 3 columns is:
>
> =SUMPRODUCT(--('Data Source'!$A$5:$A$555=$A4),--('Data
> Source'!$C$5:$C$555=D$3),'Data Source'!$B$5:$B$555)
>
> is there a shorter way to sum the 16 x3 columns without repeating the same
> equation in multiple columns then adding the values?
>
> Many thks in advs Chris