Hi Emilio,

Am Wed, 18 Dec 2019 06:51:46 -0800 (PST) schrieb Emilio Guerra:

Thank you so much, Claus. I know I'm pushing my luck and the bounds of courtesy here, but is there a way to make them count the entire column range (eg. A:A and B:B) avoiding blanks?

try:

=SUMPRODUCT((A1:A20=B1:B20)*(A1:A20<"")*(B1:B20< ""))

Regards
Claus B.
--
Windows10
Office 2016