count based on mounth

[santos85]

count based on mounth

like =COUNTIFS(C:C;A4;G:G;"=10/2010")

in need right formula

[daddylonglegs]

You can two dates to create a range, e.g.

=COUNTIFS(C:C;A4;G:G;">="&DATE(2010;10;1);"<"&DATE(2010;11;1))

[santos85]

didn't work

">="&DATE(2010;10;1);"<"&DATE(2010;11;1

i think because of this mark ;

[FDibbins]

Hi and welcome to the forum

did you try to change the ; in the dates to / or to whatever you have as a separator in your dates?

[santos85]

yes but didn't work

[daddylonglegs]

Sorry, I missed a part out - should be

=COUNTIFS(C:C;A4;G:G;">="&DATE(2010;10;1);G:G;"<"&DATE(2010;11;1))