Auto fill formula every nth cell, and look up value every nth cell in source [Solved]

Auto fill formula every nth cell, and look up value every nth cell in source

OK i know my title sounds kinda confusing, but i have a huge excel sheet that i must produce a result (please see this

sample).
Source tab contains vital information about some clients. 
In the aggregated tab (Cell C10) I created a formula that pulls the Inflows from the source in a very specific array.
So for client 1, this works fine.
Now, if i copy my formula to the client 2 (Cell C14), it
obviously wont go and look in the correct array in my source. 
What i need to do is to be able to copy/paste my formula 

=SUMPRODUCT(--(A9=Source!$A$3:$A$12)*(Aggregated!C3=Source!$Q$3:$AP$12)*("Inflow Amount"=Source!$P$3:$P$12)*(YEAR($C$4)&MONTH($C$4)=YEAR(Source!$Q$7:$AP$7)&MONTH(Source!$Q$7:$AP$7))*(Source!$Q$4))
(from cells C10 to CC10) to cells C14 to CC14, but when copied, i want the look up array to change to:
=SUMPRODUCT(--(A13=Source!$A$15:$A$24)*(Aggregated!C3=Source!$Q$15:$AP$24)*("Inflow Amount"=Source!$P$15:$P$24)*(YEAR($C$4)&MONTH($C$4)=YEAR(Source!$Q$19:$AP$19)&MONTH(Source!$Q$19:$AP$19))*(Source!$Q$16))

I will have to fill this formula to at least 100 entries down, so i need to make it work with ease
The good thing is that all look up values in the source increase by a fixed number of rows (12).
I tried playing with index/rows formula..
no luck..
any help would be greatly appreciated!

Anwsers to the Problem Auto fill formula every nth cell, and look up value every nth cell in source

Download SmartPCFixer for Free Now

Hi,

Enter this formula in cell C10 of Aggregated sheet

=IFERROR(INDEX(Source!$Q$1:$AP$24,MATCH(1,INDEX((Source!$A$1:$A$24=Aggregated!$A9)*(Source!$P$1:$P$24="Inflow Amount"),,),0),MATCH(1,INDEX((MONTH(INDIRECT("'Source'!"&ADDRESS(MATCH(1,INDEX((Source!$A$1:$A$24=Aggregated!$A9)*(Source!$P$1:$P$24="Inflow Date"),,),0),17)&":"&ADDRESS(MATCH(1,INDEX((Source!$A$1:$A$24=Aggregated!$A9)*(Source!$P$1:$P$24="Inflow
Date"),,),0),42)))=MONTH(C$4))*(YEAR(INDIRECT("'Source'!"&ADDRESS(MATCH(1,INDEX((Source!$A$1:$A$24=Aggregated!$A9)*(Source!$P$1:$P$24="Inflow Date"),,),0),17)&":"&ADDRESS(MATCH(1,INDEX((Source!$A$1:$A$24=Aggregated!$A9)*(Source!$P$1:$P$24="Inflow Date"),,),0),42)))=YEAR(C$4))*(INDIRECT("'Source'!"&ADDRESS(MATCH(1,INDEX((Source!$A$1:$A$24=Aggregated!$A9)*(Source!$P$1:$P$24="Inflow
Week"),,),0),17)&":"&ADDRESS(MATCH(1,INDEX((Source!$A$1:$A$24=Aggregated!$A9)*(Source!$P$1:$P$24="Inflow Week"),,),0),42))=C$3),,),0)),0)

Copy this to the right and to all the Inflow rows downwards.

Hope this helps.

Windows Error Reporting - To Fix Auto fill formula every nth cell, and look up value every nth cell in source

1. Go to Start button.
2. Open Control Panel.
3. Go to Windows Error Reporting.
4. Click on System and Maintenance, then click Problem Reports and Solutions.
5. Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
6. Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
7. Next, click the Advanced settings link.
8. Select Off to turn off Error Reporting.

Recommended Method to Repair the Problem: Auto fill formula every nth cell, and look up value every nth cell in source:

How to Fix Auto fill formula every nth cell, and look up value every nth cell in source with SmartPCFixer?

1. Download Error Fixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.

Related: AMD Radeon HD 7800M Win8 not working [Anwsered],I can access the internet, get on facebook and get to hotmail, but I can't play games on facebook and I can't open or respond to my e-mails,I keep getting this Media Player error when I log on my computer. [Anwsered],[Anwsered] System Hanging on shutdown and restart,Unable to get the Vlookup property of the WorksheetFunction class,Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,Troubleshoot:Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive. Error,External Hard Drive not listed in Windows 7 backup wizard Tech Support,Tech Support: I'm always being signed off so annoying,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.,Referencing data in Access using Excel [Anwsered],Need Best Way To Present Data [Anwsered],Same question but for windows 7 home edition,sometimes fullscreen won't activate [Solved],Solution to Error: We bought a new computer with windows 7 and it is constantly freezing. How do we fix this?,Solution to Error: Windows 8 update crash (2013-07-22)
Read More: Troubleshooting:Backup problem 0x8100002f - Backup skipped backing up E:\\ as it is on the backup target. Error,Solution to Error: Assistance in adding rows of information into one master sheet,Solution to Error: Automatic refresh of data between workbooks,Solution to Error: Assist me in getting a code,How to Fix - AutoCorrect Options in Word 2010?,application not found error,any problems in a team where one has Windows XP and the other has Windows 7?,Application/Object-Defined Error,An Excel formula question where hours are totalled and cumulating,Anyone know the hardware email?