Sumproduct ignore blank cells

[ekslit]

Hello Guys,

I m trying to make sumproduct formula working and i m stuck with it because it seems that it count as well my empty cells.

I have data in column A and column B and i m trying to compare both columns and count when value from column A = column B.

This is the formula: =SUMPRODUCT(--(B:B=A:A))

How can i ignore blank cells?
Thanks

 

[Toadstool]

Hi Ekslit,

Try =SUMPRODUCT(--(B:B=A:A)*(B:B<>""))

 

[ekslit]

@Toadstool ,

Working fine.
Thank you very much.