C
Chad Portman
Here is my issue I have a sheet for every day of the month and then a MTD
sheet. On every sheet Col A has the names of the Sales Rep and then Col B has
their % of sales that day. I want on the MTD sheet a formula to go through
and se first if that sales rep worked that day and if so check if they made
their % of sales goal of 68%. I want it to do this for every sheet so that
basically in the end what it gives is the number of days that agent met goal.
Not every agent is listed on every sheet they are only listed if they worked.
The sheet names are Aug 1st, Aug 2nd, Aug 3rd… etc. If it makes it easier I
can replace the sales rep names with their Emp. ID sometimes that helps with
excel. BTW this is Excel ’03. Any help is appreciated.
sheet. On every sheet Col A has the names of the Sales Rep and then Col B has
their % of sales that day. I want on the MTD sheet a formula to go through
and se first if that sales rep worked that day and if so check if they made
their % of sales goal of 68%. I want it to do this for every sheet so that
basically in the end what it gives is the number of days that agent met goal.
Not every agent is listed on every sheet they are only listed if they worked.
The sheet names are Aug 1st, Aug 2nd, Aug 3rd… etc. If it makes it easier I
can replace the sales rep names with their Emp. ID sometimes that helps with
excel. BTW this is Excel ’03. Any help is appreciated.