Ok, been messing around with this, but not getting anywhere, and issue for me is that the criteria that has to be met, is actually a range of dates, that are not consecutive.
Basically, patient database is in Sheet 1. Sheet 3 is where I want counts of how many patients meet certain criteria. First example which I have working is how many patients are from Spoke 100, Spoke 200, 300,etc. That was easy enough, just used formula - =COUNTIF(Sheet1!$A$1:$A$6716, 100) for counting the amount of patients from Spoke 100.
But next thing is more complicated. I need to count how many patients have their date in Column E, matching a certain range of dates.
For example,
Starting with spoke 100 Week 1 Monday, How do I put a formula to count how many patients have "100" in Column A, but also have a date in Column E which matches any date which is in the range for Week 1 Monday (I.e. C11 to Z11)?
May also need one more formula which is even more complicated. Same as above, count patients with 100 in column A, date in Column E in the range C11 to Z11,but will minus off any of those patients where the patients name is in a Red colour cell?
thanks in advance
Bookmarks