I Just cant figure this out, COUNTSIF I think!!

[ijones2932]

Hi, can anybody help with this please!

So I need a count by facilitator (Column G) when someone is coming up to or has reached 3 months (Column H) it shouldn't count after that date. So the count for IJ will be 0 as we are past that date

This would be repeated with a count by facilitator for 9 months and the count would be 5 for IJ as they are all before the 9 month mark but I just cant get my head around it!

Then I would need a count by how many are coming up to 12 months by facilitator.

I hope this make sense as I've been baffled for 2 days trying to figure this out so I've had to reach out



,

 

[ijones2932]

So you mean any date that is greater than yesterday?

No any date greater than the actual date in column L. So it counts it's if it's over the 12 month date set in column L

 

[Fluff]

Ok, how about

=COUNTIFS('Current Cohort'!G:G,P10,'Current Cohort'!L:L,"<"&TODAY())

 

[ijones2932]

Ok, how about

=COUNTIFS('Current Cohort'!G:G,P10,'Current Cohort'!L:L,"<"&TODAY())

I will give go tomorrow pal, kids are home now. Thank you so much for your help and patience

 

[Fluff]

Ok

 

[ijones2932]

@Fluff Thank you so much for your help! That last one worked as well.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[ijones2932]

@Fluff Could I borrow your expertise on this again. I've come to the point where I've inputted all my data and I have gone wrong somewhere with explaining what I needed. So from the screenshot each person has a total caseload then below are what should be how many they have that are

3 month from induction date (column C)
9 month from induction date (column C)
12 month from induction date (column C),

So these 3 numbers should then add up to the total caseloads.

I hope I've explained this correctly

Thank you

 

[Fluff]

There's not much I can do with an image, I would need the actual data.

 

[ijones2932]

Hi, thank you for the reply. Would you be able to work it off the same data I sent previously as I cant send the actual data as I work for the NHS and it confidential.

 

[Fluff]

No, because I have no intention of typing everything out.