Try this:
First Issue:
Lookup SUM in Excel Help.
Under the SUM topic there should be a link to "See Also".
Click that....On my version, the following are listed:
AVERAGE
COUNTA
Math and Trigonometry functions
PRODUCT
SUMPRODUCT

Hopefully, your version will include the Polish version of SUMPRODUCT.

Second Issue:
Many functions return TRUE or FALSE. SUMPRODUCT will not recongnize those as
numbers and cannot add/multiply them. By prepending -- to the function we
force Excel to convert TRUE/FALSE to 1 and 0, respectively.
The first - converts TRUE to -1.
The 2nd - converts the -1 to 1.

However, in the case of COUNTIF, that function actually DOES return a
numeric value so the -- was unnecessary. I'm sure I just included it out of
habit.

Hopefully, that helps solve your problem.

***********
Regards,
Ron


"Uka P." wrote:



Ron Coderre wrote:

Try this:

If your values are in Cells A1:B10

C1: =SUMPRODUCT(--COUNTIF(A1:A10,B1:B10))


Does that help?




Nope :-(
My excel doesn't get it, it says the formula is wrong, because 'cauntif"
needs to have specified data and conditions.

Maybe the problem is with langauge - you wrote it in English, and I work
with Polish version of excel, so I have to translate the formula into
Polish. I know what "countif" is in Polish, but I can't figure out the
"sumproduct" - which I suppose is not the same as "sum"? Why don't you
paste here the article according to "sumproduct" form your English
excels' help, so I can match it to any of my "sums"?

I also don't get the usage of "--". Am I supposed to put it exactly as
you wrote, exchanging only English "countif" to Polish "licz.jezeli"? Or
is it a symbol standing for something different, which I didn't get?

Thanks for your help. :-)

regards,

--
Uka P.