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.
Please see the attachement.
Please help
Bookmarks