Count the number of items received in a certain month

S

Steven

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
cell,
then in next cell totl number recived in April and so on.

Any help?
 
J

Jacob Skaria

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

Sum of March
=SUMPRODUCT(--(MONTH($A$1:$A$1000)=3),--($B$1:$B$1000))

Sum of April
=SUMPRODUCT(--(MONTH($A$1:$A$1000)=4),--($B$1:$B$1000))

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

How can count the number of cells that fulfill certain criteria in other cells 2
weeks in a month 1
Count a cell in month format 5
Sum of Numbers of a Rolling 6 month Period range 0
How to count the occurrence? 3
Find the position of a date 6
calculate number of days 7
Pulling Last Balance 3

Top