Hi Guys,
Problem with Count A with Multiple Criteria, i just wanted to use a formula to count the number of Agent with multiple criteria instead of using pivots.
Criteria are:
count the number of agents based on the date selected and date created and application status is equal to Completed and cancelled only.
i have attached the dummy file for reference.
many thanks.
Hi, is this what you need? If so, please mark the thread as closed and show thanks by clicking the "Add Reputation" button at the bottom of this post.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Here is your worksheet showing the number of Completed, and the number Cancelled with the date criteria. See Sheet2 to see what exactly is extracted. This extraction matches the number of the calculations. See also the range with duplicates removed.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks