# Countif Date less than 3 months from another Date AND another column=certain month

1. ## Countif Date less than 3 months from another Date AND another column=certain month

Hi Everyone,

First post here. Bare with me.. I'm extremely new to this. I'm trying to do something difficult on a spreadsheet and need some assistance. I've attached it below.

So I am trying to count (in row 58) people that are enrolled in certain month(column D) AND Column AL <= 3

I will be doing the same in Row 59, but for folks where column AL = between 3 and 6 months.

Obviously if I can do this with removing column AL altogether, that would be preferable.

Thank you!!

2. ## Re: Countif Date less than 3 months from another Date AND another column=certain month

I also need to note that clearly some of my formulas are going to run into issues when next year rolls around and I have multiple months, but different years. I need a way to change the formulas at the bottom to only include 2014... And I will make another large section for 2015.

3. ## Re: Countif Date less than 3 months from another Date AND another column=certain month

Have a look at the attached for one way of doing this. Any good to you?

It's based on 30 day months so within three months would be 90 days or less and 3-6 months would be greater than 90 and less than or equal to 180 days etc.

I've changed the date format in row 51 to help out with replicating the table for other years.

No need for column AL.

BSB

4. ## Re: Countif Date less than 3 months from another Date AND another column=certain month

You are absolutely phenomenal for that. Works like a charm.

Could you possibly help me convert the other formulas to operate base on the month/year in row 51 as well? The formulas you have added are excellent, but are way over my head.

Thank you!

5. ## Re: Countif Date less than 3 months from another Date AND another column=certain month

Here you go. All done.

These formulas you could use COUNTIFS for (it's a little more efficient than SUMPRODUCT), but I've used SUMPRODUCT for them as didn't want to confuse you with more formulas.

BSB.

6. ## Re: Countif Date less than 3 months from another Date AND another column=certain month

Thank you SO much!

7. ## Re: Countif Date less than 3 months from another Date AND another column=certain month

No problem. Happy to help.

BSB.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1