Easiset way

Debug.Print
Evaluate("SUMPRODUCT(--(A1:A10=""abc""),--(B1:B10=17),C1:C10)")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tarek" wrote in message
...
Dear all,

Now I m just testing and learned about SUMPRODUCT parameter of excel.
But actually, I need to translate and applicate in macro(i need the
syntax).
So I can't solve it now!

Anyone can help me and feel greatly appreciate !

--
Regards,
Tarek ^^'

-----------------------
Tarek's WorkShop