Hi,

Look at this little table:

a 1
z 2
a 3
r 4

I want to count the number of occurences of "a". I know there is a easier way to do that using COUNTIF, but i'm experimenting with array formula and i did it in two ways:

COUNT((L7:L10="a")*(M7:M10)) -> this gives 4 !?!
COUNT(IF(L7:L10="a";M7:M10)) -> this gives 2

I thought that both formulas were the same (i did the same with SUM and both formulas produce 4). So why does the first formula produce a wrong result?

Thanks
beamon