Meeting Goal?

[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.

 

[Chad Portman]

Never Mind I cheated. I just made a Col on the MTD for each day for each
Sales Rep. And had it do a Vlookup to pull the data auto. Then hid those col
and made a new one that did a countif. Like I said cheating but it worked.