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

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

Thanx for the answer, but nothing happened. I have no experiences with VBA
and macros... could you be more specific, ot it is the whole answer?

MG

Dave Peterson pÃ*Å¡e:

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

sorrryy,I was wrong. I've got it now, thanx for your help.
MG

Dave Peterson pÃ*Å¡e:

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