sumproduct

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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:
 
sorrryy,I was wrong. I've got it now, thanx for your help.
MG

Dave Peterson píše:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to over write Windows Date format? 3
sumproduct text and numbers same column 2
Excel 2007 changes links in cells 3
Change of language version 5
Multisheet range in SUMPRODUCT? 5
Vlookup bringing back #N/A 2
If I change a point for a coma between two numbers format dont cha 1
multiple sumproducts and now formula is too long 3

Back
Top