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

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