Thread: Count
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hardeep kanwar[_2_] Hardeep kanwar[_2_] is offline
external usenet poster
 
Posts: 14
Default Count

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