Count formula required that falls within a date range

[rajtak]

I need a formula to count cells of other columns that falls within the dates of July month. Please check the screenshot below and let me know your suggestions. It should ONLY count the non-blank cells of Micky



Thanks in advance

 

[Aladin Akyurek]

This also works for August

=COUNTIFS(A:A,">7/31/2013",A:A,"<=8/31/2013",C:C,"<=8/31/2013")

...

Still not well-formed: Enter in C 41518 in a cell for Micky.

 

[rajtak]

Hi Aladin,

Yes, i got it what you were trying to say, my formula skips the count of large values (41518) and alphanumeric values don't know why. Your suggestion is working perfectly. Thank you very much

 

[Aladin Akyurek]

Hi Aladin,

Yes, i got it what you were trying to say, my formula skips the count of large values (41518) and alphanumeric values don't know why. Your suggestion is working perfectly. Thank you very much

You are welcome. The C range needs to be tested differently, not as a case less thanor equal to some arbitrary date. using whole column references as you did we would have something like:

=COUNTIFS(A:A,">7/31/2013",A:A,"<=8/31/2013",C:C,"<>")

Or somewhat fancy:

=COUNTIFS(A:A,">7/31/2013",A:A,"<=8/31/2013",C:C,"<"&9.99E+307)

These formulations require you to know the end of months days, therefore risky. Hence:

=COUNTIFS(A:A,">=8/1/2013",A:A,"<="&EOMONTH("8/1/2013",0),C:C,"<"&9.99E+307)