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]

Sorry for messing you around, what would other data would you need?

 

[Fluff]

I would need all the data in order to see why things are not adding up.

 

[ijones2932]

Ok, not to worry as I can't send all that unfortunately. I just thought I'd explained it wrong and it was using today's date as a point of reference rather than the date in column C as it has TODAY in the formula. Thank you anyway