Count the number of items received in a certain month

[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?

 

[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