In excel is it possible to perform CountIf AND Operation for two different Columns.
For example look below
First Name | Last Name
=====================
Abil | Sam
Abil | Jack
Abil | Sam
Abil | Sam
Thomas | Sam
I need to COUNT of the Number of "ABIL" + "SAM" in the Excel sheet .
Here in the example above the result should be 3.
I tried for a long time, but did not succeed something like
=COUNTIF(AND((A1:A9,"=ABIL"),(A1:A9,"=Sam")))
Any help to solve my Issue is greatly appreciated.
Bookmarks