U R quite right Iliace!

Sorry 4 replying late but I was bz in my exams.

How can u devise a custom function like:
MyRate(A1:A20,B1:B20,C1:C20,"A")

"iliace" wrote:

How do you intend to pass the C1:C20 part of the argument?



On Nov 26, 1:28 pm, FARAZ QURESHI
wrote:
Hello every1!

Can anyone devise me a piece of code to formulate a custom function like:
MyRate(Array1,Array2,Criteria)

To work for a function like:
=SUMPRODUCT(--(A1:A20="A"),B1:B20,C1:C20)/SUMPRODUCT(--(A1:A20="A"),B1:B20)

As:
MyRate(A1:A20,B1:B20,"A")

All your assistance and expertise shall be highly obliged.

Thanx in advance!!!