Excel Date Range Issues

[regulus]

I'm trying to Count if my specified date ranges falls between certain dates.

So with other words, I'm trying to add "+1" every single time I enter a date in January 2015 in my specified Dates column. I use this simple formula;

=COUNTIF(Records!F3:F456, ">31/12/2014")

It works fine for my January cell but my issue comes when I move on to my February cell. My January cell keeps adding every entered date to itself. So I need something in that formula which tells my January cell only to look for entries made between 31/12/2014 and 31/01/2015. I've tried;

=COUNTIFS(Records!F3:F456, ">31/12/2014 <=31/01/2015") but it only takes the values down to zero.

I hope I explained this clearly enough.

 

[regulus]

Sweet, I actually managed to solve it a while ago with this formula;

=COUNTIFS(Records!F3:F456, ">31/12/2014", Records!F3:F456, "<31/01/2015") ---- which really is the same thing

but yours look more clean for some reason so I'll give it a shot

I don't suppose I could take the pee pee and ask one last question. In the same row of the 'January' date I enter, is a monetary value. So if I enter my date in Column F, the Column J on the same row has a dollar value I manually enter. How do I add those all up for the month if there's 10+ rows that's all connected to January?

 

[regulus]

Lovely, it works great. Thanks for the pointer mate!