building arrays from cells and/or ranges

[Leon V (AW)]

I have the following formula

Please Login or Register  to view this content.

which works fine when my inputs are =CofM(RangeA,RangeB)
however I need it to also work with =CofM((cell1,cell2,cell3),(cell4,cell5,cell6))

How do I get it to accept RangeA or cell1,cell2,cell3 or cell1,RangeA,cell2 as Array1?

I have been trying to use =SumProduct((cell1,cell2,cell3),(cell4,cell5,cell6)) in varying forms to see if SumProduct can build an array from selected cells (similar to how Sum can be =Sum(range) or =Sum(num1,num2,num3)) with no luck so far.

[Debraj Roy]

and how you tackle.. sumproduct part.. as sumproduct needs same length of range..

[JosephP]

perhaps

Please Login or Register  to view this content.

[Debraj Roy]

Hi josie,

cell1,RangeA,cell2

that line make me confused.. that OP wants.. parameters as "Param Array"..
Crossing finger, that OP dont want something like.. A2,A5:A17,B9

[JosephP]

entering
=CofM((cell1,cell2,cell3),(cell4,cell5,cell6))
passes 2 arguments (both ranges albeit with multiple areas for each range) so no need for a paramarray ;-)

[Leon V (AW)]

I think that has worked. I was worried that n would be limitted to 255 but I have tried a range of 300 and it works. thanks for that