Excel: Counting Two Columns based on Criteria

Hi All, I am working on spreadsheet 2. I want to go into spreadsheet1 (tab1), search column A for "Yes" and column B for "George", if both criteria is met I want to return the number of entities, how is this done? Thanks

This question generated 17 answers. To proceed to the answers, click here.

This thread is current as of February 15, 2017.

For more resources for Microsoft Excel