Count entries in a month

[bnwash]

My work sheet has date entries which I wish to use to create a graph
I need to count them for eack month

1-Aug-12
10-Aug- 12
2-Sep- 12
22-Sep-12
30-Sep-12
and so on

I am looking for a formula which will look at the col [a] range 4 - 40 and give the following result

Aug- 12 - 2
Sept-12 - 3
and so on

Assistance appreciated

[FDibbins]

i think a pivot table will give you what you want here, and you can even create a pivot chart too, give it a shot and let me know how you make out?

on a side note, 1 of the reasons the forum asks for which version you are using, is so that we can tailor suggestions/solutions to your version

[bnwash]

Using Excel Office 10
I am not firmilar with Pivot tables - Can you head my in the right direction

[FDibbins]

can you upload a sample workbook please, i can walk you through it

[bnwash]

I have attached a rough example.
The sheet would be a growing form as new data is entered each month

[FDibbins]

if you change the entries in the summary table to actual dates, you can use this, copied down...

=COUNTIFS($A$2:$A$13,">="&A18,$A$2:$A$13,"<"&A19)

[bnwash]

Many thanks appreciate you assistance.
Can I also ask can I use a similar formular if I was to place amounts in Col C
In otherwords - you formula allows me to count the items in each month but I would also like to find the value

Can you assist please

[FDibbins]

if you want to "find the value", i assume you want totals? if thats the case, you can use the sumifS() function

Also, i would suggest that you include you're office version in you're profile, so that members know which functions to suggest for you (for instance, the file you uploaded is .xlsx - this tells me you are using at least 2007. the sumifS() function is not available in excel versions before 2007)

[bnwash]

Thanks.
Earlier in this post I indicated I was using Office 10.
What I was additionally needing is the sumif formular which will add yo the values in say col c giving a monthly result like the result I get with the code privided by Dibbins above.
The example I attached only included XXX in C but this in the real sheet would have a dollar value

Thanks for any assistance

[FDibbins]

assuming you have values in column B, use this, copied down and across...

=SUMIFS(B$2:B$13,$A$2:$A$13,">="&$A18,$A$2:$A$13,"<"&$A19)

[bnwash]

Many, Many Thanks for your assistance

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)