Solved Formula to count number of rows that meet 2 criteria.

August 1, 2013 at 06:57:35
Specs: Windows 7
Hello, I am looking to set up a summary chart about a list of contacts on Excel. Essentially what I am trying to do it get a summary chart that displays the number of contacts who meet 2 conditions (Job Role and Department). Currently my contact spreadsheet is set up so that each contact's information is contained in one row. There are several different columns that contain that contacts information. What formula could I use in the summary chart so that it automatically determines the number of people that meet the specified criteria. The logic of the function would need to be something like:

For a range of data, count each row where column x = "position 1" and column y = "department 1"

Thank you very much for your help!

See More: Formula to count number of rows that meet 2 criteria.

Report •

August 1, 2013 at 07:03:21
✔ Best Answer
Assuming that you are using Excel 2007 or later, try the COUNTIFS function.

COUNTIFS function

Applies criteria to cells across multiple ranges and counts the number of times all criteria are met.

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

August 1, 2013 at 08:05:14
Thanks! I had tried the COUNTIFS function prior to posting and the numbers I was getting weren't correct.... But seems to be working now!

Thanks Again!

Report •

Related Solutions

Ask Question