sumproduct

M

mg

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

Dave Peterson

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.
 
M

mg

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:
 
M

mg

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

Dave Peterson píše:
 
Top