Copy the following formula and paste it in G1, then use Fill Down to fill it down to as many cell as you need
Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
If the name in "d" is different how will the formula know to count cell
4 with active dates
41 total students
So you want to count the number of occurrence in column D where 1) the corresponding values in E are dates, and 2) the corresponding values in E are not dates. Correct?
Count Chicago students active
Count Madison students active
Count Johnsburgh students active
Count total inactive students
Count total students list (without duplicates)
Does this help?
Ok here is the formula that counts Chicago active (Chicago should be in column D, and the dates in E and F)
To count other names replace "Chicago" with the name that you would like to count
Hope this helps
The formula has a Circular Reference Warning message and the answer seems to be zero over and over.
The problem is not with the formula. You either have placed the formula in the wrong cell or you have other issues in that file. I can send you a sample file to show you how it works
However if you want me to check your file and diagnose the problem you will need to open a new question and assign an appropriate amount.
I don't understand;
My problem is the same as before I received your answer, your formula is not working.
Ok send me the file today and I let you know if the issue is with the formula or something else.
I tried the formula in the Greater Chicago total, see attached excel document.
You cannot put the formula in the same columns that it refers to. The formula refers to F:F while the formula itself is in column F. Place the formula in another column and you will be good to go
I hope this helps