countif help

[regankl]

I am trying to create a formula that counts the number of filled in cells in one column if the dates are <x> in another column. I can do it if it's a specific value I am doing, but I want the count for any cell with a value that is filled in (for example) in the month of October.

Does that make sense?

Thank you for your help!

 

[barry houdini]

In Excel 2007 and later you can use COUNTIFS, put the 1st of the month in D2 and try

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

Assumes dates in A and values in B

 

[regankl]

This is what I have in my other formula that counts the number of "Submitted Late" in between 2 dates. I want the submitted late part to count the number of nonblank cells.

=COUNTIFS('YTD Deliverable Report'!$AJ:$AJ,"Submitted Late",'YTD Deliverable Report'!$M:$M,">="&B4,'YTD Deliverable Report'!$M:$M,"<"&B5)