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

G

Guest

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
 
G

Guest

try
=SUMPRODUCT(--(and(mod(column($A$5:$AT$555),3)=1,'Data
Source'!$A$5:$AT$555=$A$4),--('Data
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count how long it will takes for a number to repeat 1
Matching a value that appears multiple times 11
Please, need help, I have to prepare a report today. 3
Multiple levels of sumif? 3
I need to add an IF condition to a formula 9
How do I count the number of times a value appears? 2
Your help please in updating a column using Count or an Array Formula 3
Circular Equation? wrap on 5 business days.. 1

Top