Perfect

Both Formulas Work Prefectly


Thanks Jacob Skaria and Faraz Qureshi

Hardeep kanwar

"Jacob Skaria" wrote:

Dear Hardeep

Try the below

=SUMPRODUCT(--(A1:A100="A"),--(B1:B100="PAI"))


If this post helps click Yes
---------------
Jacob Skaria


"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