Udf paramarray

[daboho]

I want to be understand use paramarray
This is my problem
In (a1:a20) contain date,string,numeric
I want use udf paramarray to sum.count of date,string,numeric

Please Login or Register  to view this content.

While i am use function in b1 and drag to d1
In b1=.count (date),c1=.count(string) and d1=.count(numeric)

[xlnitwit]

Hi,

What makes you think Paramarrays are relevant here?

[daboho]

Hi xlnitwit forgive me,i dont know how to use paramarray
I want you explain me,give me example thankyou

[jindon]

Besides parramarray, you can't evaluate date using Value2.

[xlnitwit]

A Paramarray is used when you don't know how many parameters will be passed. Think of the function SUMIFS which can have a variable number of criteria pairs passed to it after the range to sum.

It sounds to me as though you want to return an array, not pass one.

[daboho]

Thank you jindon
Xlnitwit
Give me sample problem

[jindon]

In (a1:a20) contain date,string,numeric
.
.

While i am use function in b1 and drag to d1
In b1=.count (date),c1=.count(string) and d1=.count(numeric)

B1
=IFERROR(DataTypes($A1:$A20,COLUMN(A1)),"")
fill right

Please Login or Register  to view this content.

[xlnitwit]

Here is a minimal version of a SumIfs function

Please Login or Register  to view this content.

which you can call with varying numbers of criteria, such as
=MySumIfs($C$1:$C$15,$A$1:$A$15,"Item1")
or
=MySumIfs($C$1:$C$15,$A$1:$A$15,"Item1",$B$1:$B$15,"test1")
like the worksheet function.

[daboho]

Thankyou jindon and xlnitwit

[xlnitwit]

You're welcome. Please remember to mark the thread Solved using the Thread Tools link at the top of the page.

[daboho]

Xlnitwit my handphone not have fasilitas solved bellow my picture