Count the number of items received in a certain month



I am trying to get my excel sheet to count the number items received in a
certain month. For example

02/Mar/09 59
04/Apr/09 62
01/Mar/9 25
01/May/09 25

I there want the total number of items received in March adding togther in a
then in next cell totl number recived in April and so on.

Any help?



Jacob Skaria

Assuming you have dates in ColA and values in ColB use the below formula

Sum of March

Sum of April

If this post helps click Yes

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Count dates within a Month 4
weeks in a month 1
Pulling Last Balance 3
Need a Function 5
Count a cell in month format 5
calculate number of days 7
Counting dates with conditions 2
Counting dates 12