Count the number of items received in a certain month

  • Thread starter Thread starter Steven
  • Start date Start date
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?
 
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
 
Back
Top