Count if date is between two dates

[natemoss1218]

I think I'm an idiot for this one because I know this is simple, but my brain is not working.

Here is the spreadsheet: Copy of Untitled spreadsheet

I am trying to get a count of how many of a certain item were in inventory between the start date and end date. Basically, if start date is greater than or equal to intake date AND end date is less than or equal to outcome date that means it was in inventory at some point in that month. Countifs isn't giving me what I need for some reason.

HELP ME!

 

[Sufiyan97]

What do you want to count?

 

[Fluff]

How about

=COUNTIFS(A:A,"<="&D2,B:B,">="&C2)

 

[natemoss1218]

What do you want to count?

How about

=COUNTIFS(A:A,"<="&D2,B:B,">="&C2)

Ah, perfect thank you! I had mine backwards. This is exactly what I needed. I knew I was an idiot. Cheers!

 

[Fluff]

You're welcome & thanks for the feedback.