# Count values with conditions

1. ## Count values with conditions

Hi Team,

i have two sheets and sheet 1 has project details like different project Ids, names of people assignet to each project, rate of each person, location of each person etc.

i am trying to find the count of people with conditions.

eg: i would like to know how many people are assigned under the project "1111" whose location is "Onshore" at the same time the rate is "50".

The sheet 2 contains the template where the count has to be updated.

2. ## Re: Count values with conditions

Using your posted workbook...this regular formula, copied down, returns the counts:
``Please Login or Register  to view this content.``
You might want to convert your sheet1 list to an Excel Table (Home.Format-as-table...follow the prompts)
Then your formula would be more intuitive and descriptive:
``Please Login or Register  to view this content.``
Is that something you can work with?

3. ## Re: Count values with conditions

You could add filters, Data-Filters or probably use the formula COUNTIFS, I have to go now but I can take a look later/tomorrow if you didn't solve it.

4. ## Re: Count values with conditions

G2:

=SUMPRODUCT((Sheet1!\$A\$2:\$A\$19=A2)*(Sheet1!\$F\$2:\$F\$19=B2)*(Sheet1!\$G\$2:\$G\$19=C2))

and copy down

There are currently 1 users browsing this thread. (0 members and 1 guests)