Why a parameter behaves like an array in SUMPRODUCT Function..?

It's a fairly generic question that will probably have multiple possible answers -- choosing between them will depend on the context you are working in.

In my case, when I want to pass an array to a UDF, I usually pass it as a RANGE object. A simple sum function:

Please Login or Register  to view this content.

From there, you will probably need to provide an example of what you are trying to do.