Countif during a month

[Beowulfe]

I am trying to build a table with Labels of each month. I am trying to find out if there is a way to count the number of items from a different table that have a date between the beginning and ending of the month in the column.

A2 = Mar
B2 = countif(E:E, falls within March)

I can manually do a countifs and say if greater equal to Mar 1 or less than Apr 1 but I wanted to know if there is an easier more dynamic way.

Thanks.

[tlafferty]

=sumproduct(--(month(e:e)=3))

[Beowulfe]

Ok, to step it up a notch let's try this:

Column A is severity type
A2 = S1
A3 = S2
A4 = S3

B1 thru D1 are Mar through

I am trying to count the number of cases that have the corresponding Severity type and fall within that month. The data is in columns F for severity and G for date.

So B2 should count how many cases from F:G that are S1 and are in the month of Mar

[tlafferty]

=sumproduct(--(month(G:G)=3)*(F:F="S1"))

[arthurbr]

Please Login or Register  to view this content.

This approach works as long as the month to search is not January.
If it is, and if there are values in less than the whole column ( or there are 0's somewhere in the column) you will always get 1048576 as answer.
So, the real range should be used instead of e:e or the formula could be changed to

Please Login or Register  to view this content.

[Beowulfe]

I got it to work. Thanks for the help.