Count base on criteria

[KIM Chanthan]

Hi,

Do you have any other way to count 1 column base on other column?

Please view attached file.

Thanks for help.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[bosco_yip]

In D3, non-array formula copy down :

=SUMPRODUCT((A$2:A$10=C3)/COUNTIFS(A$2:A$10,A$2:A$10,B$2:B$10,B$2:B$10))

Regards