Hi,
I'm trying to count the no. of users that have submitted work returns (what work they've done that day) where multiple criteria is met. I am using Excel 2003. I cannot attach any data due to stupid restrictions with our software. So, let's say the data displays as follows.
Column a = Persons name
Column B = Manager (not relevant but shows in my data)
Column C = Team name
Column D = Grade (D or E)
Column E = date
For example, can someone help me with a formula in Excel 2003 that will count the no. of users that (as an example) work in the 'Health and Welfare team' at Grade D that have submitted data between the dates of 01/04/15 and 03/04/15. If I could upload some data I would but I can't. In an ideal world the data would show multiple (let's say 3) people that have submitted data that meet all of that criteria but where each one has submitted data 2 or more times. This way I will be able to understand the solution better when displayed. So if 3 people have submitted data that meet this criteria and there are 7 entries for example I would want the result to be 3 as this is the no. of unique users.
I would really appreciate any help someone can provide!
I have tried using DCOUNTA with an If statement (to start, thinking I could then go onto multiple if statements) but not having much luck.
Bookmarks