Excel 2007 : Counting With Multiple Criteria Including Date Range

[skolo]

I am trying to run an active count of all package sign ups on my website. In Sheet 1, in column B are the package names and in column E are the sign up dates. In Sheet 2, I am trying to calculate package sign ups by month, with the package names on the vertical (Rows 2-6) and the months on the horizontal (Columns B-T).

My thoughts are that there is a CountIf formula that would be able to accommodate this.

I understand that pivot tables would be able to accommodate this, but am looking for an equation that will do the same. Ideally, the equation would reference the horizontal month cell in Sheet 2 and the vertical package name cell in Sheet 2 to calculate from the master reference in Sheet 1.

Anyone have suggestions for a formula that would be able to accommodate this?

[Cutter]

Could you upload a small sample file?

[skolo]

Please see attached for sample.

[Cutter]

First - change the "Month" headings on Sheet 2 to first of month dates.
Second - Place this formula in Sheet 2 B3:

=COUNTIFS(Sheet1!$B:$B,Sheet2!$A3,Sheet1!$E:$E,">="&Sheet2!B$2,Sheet1!$E:$E,"<"&EDATE(Sheet2!B$2,1))

Third - there is no match for Sheet 2 A3 on Sheet 1 so in the attached I changed it to "Silver"

[skolo]

That works great, thank you so much!

[Cutter]

You're welcome.
Don't forget to mark your thread as SOLVED - click FAQ at top of page for instructions.