Use:

=SUMPRODUCT((A1:A12="A")*(B1:B12="PAI"))

"Hardeep kanwar" wrote:

Hello Experts

I looking for a formula that will count the number of instances of "A" in
column A AND "PAI" in column B.

Eg.

A PAI
A RENU
A PAI
A PAI
A RENU
B PAI
B RENU
C PAI
C PAI
D RENU
D PAI
E ADITYA

Formula Result Should be =3

Thanks in Advance

Hardeep kanwar