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
Bookmarks