building arrays from cells and/or ranges

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.

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

perhaps

Please Login or Register  to view this content.

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

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 ;-)