Hi Guys,
Hoping for your help again.
I am trying to count how often a data set appears in each month.
I am trying to do it twice once with one argument and then again with two arguments ( i think)
I will try and explain against the sheet i have attached.
So...
first of all in cells E5 - P5 i would like to count how many times "Area one" appears in the list in the blue table in column N in each month in column H. So for example i can see "Area one" appears 3 times in the table in May 24 in column H, so in Cell F5 i would like it count 3.
Second off, I kind of what the same thing, so in cells E10 to P10 i want to do the same count, but this time only include ones that have "stage 3" in column L, so again if we take Area one as an example and the month of May, I can see Area one appears 3 times in may, but only twice with "Stage 3" in column L, So in cell F10 i would want it to count only 2
I hope that makes sense, sometimes i find it hard to articulate what im after :|
Thanks in advance
Luke
Bookmarks