Count

H

Hardeep kanwar

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
 
J

Jacob Skaria

Dear Hardeep

Try the below

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


If this post helps click Yes
 
H

Hardeep kanwar

Perfect

Both Formulas Work Prefectly


Thanks Jacob Skaria and Faraz Qureshi

Hardeep kanwar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count but in Diffrent way 6
Convert hyperlink function into hyperlink 4
If-Then Statement 1
SUMIF with multiple criteria 5
Set up for table to calculate "who owes what to who?" 1
Programatically saving an excel .csv file to .xls file... 1
Set up for table to calculate "who owes what to who?" 0
Remove all Characters Remains only Numeric Data 5

Top