Getting Percentage with CountIF Formula? I think..

[sinema]

Hi,

I'm trying to find a logical way of doing a task that's not going to take me 100 hours, which I'm learning that this isn't a bad idea as it teaches me more and more about excel.

I'm trying to the total amount of people showing up for duty on certain days.

My call center sends out a request when we telephone storms happen. We request a certain amount of people and they can respond to the shift leader if they wish to work. We have a system in place that allows us to automate this and when the shift leader sends a call out they can input the amount of people they are wanting to get and the system will cycle over a period of time until that numbers reached.

I'm needing to find the responses and percentage to this for a report without including duplicates...

For example, if Team 1 is called on 06/11/2019... 5 times.. requesting for 5 people each time and out of all 5 calls only 2 people responded.. I'm trying to capture that 2 out of 5 responded and not 2 out of 25...

I'm thinking that I would use =COUNTIFS and filter the Team Column, the Date Column ..

I've tried a couple ideas and they work (hit and miss)

I've tried =COUNTIFS(TeamsColumn, TeamName, DateColumn, Date, StaffRequested, NumberRequested) this gives me the number of times the "NumberRequested" appears in a column that has the TeamName and the Date. I then take that and /StaffRequested cell on that row.

This gives me a % but sometimes that number is correct and sometimes it is not.

Any suggestions?

 

[Gerald Higgins]

Hi, welcome to the board.

For me, it's difficult to answer this without seeing how your data is laid out.

Can you post a small sample of your data, showing the relevant fields and some typical entries ?
Make the data up if you don't want to show real data.