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!

Assuming that you are using Excel 2007 or later, try the COUNTIFS function. COUNTIFS function

Description

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

Syntax

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

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

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!

Ask Your Question

Weekly Poll

Do you think Microsoft can save the Surface Book lineup?

Discuss in The Lounge

Poll History