Countifs function

[Jbarns92]

I need a countif function involving certain items and date range.

I figured out the first one but the next one and two after are giving me trouble.

I have the first part of it where it draws the first item but help with the section.

I need a countif function where the range is list of dates the criteria needs to be something that will pull the cell (which has a date) and say greater than buy less than cell +7

The next will be countif great than cell +7 but less than cell -=14

The final will be countif greater than cell +14


Please advise me with any ideas

 

[Joe4]

Welcome to the Board!

I figured out the first one but the next one and two after are giving me trouble.

Can you post the formula you have working? It will give us an idea of your data structure.

 

[Jbarns92]

Something like

=COUNTIF(B1, ">A1" but "<=A+7")
=COUNTIF(B1, "Between A1+7,a1+14"
=COUNTIF(B1, "<=A1+14"

Trying to calculate shipments sent out in a week. Within two weeks and over two weeks of certain dayes

 

[Joe4]

I thought you said that you had one working? I don't think any of those will work, as written.
You also usually have a whole range, not just a single cell in your first argument (you are not just counting one cell, right?).

Here is a link of the COUNTIF function and some examples: https://support.office.com/en-us/article/COUNTIF-function-e0de10c6-f885-4e71-abb4-1f464816df34
Note that there is also a COUNTIFS function, which lets you use more that one criteria: MS Excel: How to use the COUNTIFS Function (WS)

Take a look at those, and see if those help you figure it out. If you are still having issues after reading those links, post back here.

 

[Jbarns92]

My first one is working where it just equals the cell. I can't figure out how to add the +7, 7-14, 14+. Ranges I want to pull

 

[Joe4]

Except for the last one, you will probably need to use COUNTIFS, as "Between" is really two criteria, one greater than some number, and one less than another number.

Here is a real nice example that shows you how to write a COUNTIFS function to return your count between two dates: Count the number of Excel records that fall between two dates - TechRepublic