Etien,

SUMPRODUCT won't work as a worksheetfunction, you need to evaluate the
formula

Evaluate("=SumProduct((A1:A3 =""X"")*(B1:B3=""Y""))")


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Etien " wrote in message
...
Hi there,

Is there a way to get WorksheetFunction.CountIf and .SumIf to work with
2 conditions?

I know how to use

SUMPRODUCT((xRg/aCondition)*(yRg/bCondition))

and

SUMPRODUCT((xRg/aCondition)*(yRg/bCondition)*(zRg to count))

in Excel, but could not find a way to translate this into VBA code...


Thanks a lot


---
Message posted from http://www.ExcelForum.com/