Using SUMPRODUCT with different array lengths

[cbiwia]

I'm trying to copy a SUMPRODUCT formula to other cells, but I have different array lengths. Is this possible or will have to continue to copy and paste the formula to the new cell and manually adjust the arrays? Is there a way Excel can find the breaks/array length difference?

Thanks,


RJ

 

[Aladin Akyurek]

Could you describe what you mean by way of an example?

 

[cbiwia]

https://drive.google.com/file/d/0B1DHa743SrxFSUhSNVU0MEdMSTg/edit?usp=sharing

Hope this helps!

 

[Aladin Akyurek]

https://drive.google.com/file/d/0B1DHa743SrxFSUhSNVU0MEdMSTg/edit?usp=sharing

Hope this helps!

No it doesn't, unless I retype everything into Excel...

 

[cbiwia]

Here is the Excel document for download.
https://docs.google.com/file/d/0B1DHa743SrxFcGVOZTBwQkUyREU/edit?usp=sharing

 

[Aladin Akyurek]

Here is the Excel document for download.
https://docs.google.com/file/d/0B1DHa743SrxFcGVOZTBwQkUyREU/edit?usp=sharing

That's for someone into VBA. There seems no be no obvious clue where to copy the target formula.