Try this to find the translation:

Open excel
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate windows

type this and hit enter:

range("a1").formula = "=sumproduct(--(b1:b10=1))"

Then back to excel and look at A1 of that worksheet.

mg wrote:

the sumproduct function is not available in my excel 2003, why?
i have the czech version, is there another verb for sumproduct in czech?

--

Dave Peterson