Getting Percentage with CountIF Formula? I think..

sinema

New Member
Joined
Jun 1, 2019
Messages
2
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?
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
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.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,238
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top