Help! I am trying to create a formula in Excel to count the number of
occurances that two particular variables both appear. I.E. Start Date and #
of Days.

Example:

Column A Column B
Start Date # of Days
1/7/09 31
1/14/09 14
1/21/09 23
2/4/09 38
1/7/09 46
2/4/09 16
1/7/09 54
1/7/09 17

I have tried following SUM PRODUCT formula and several other variances but
can't seem to get it work. Any ideas?

=SUM((Sheet1!$A$3:$A$9="1/07/2009")*IF((Sheet1!$B$3:$B$9!<31),1))
=COUNTIF((Sheet1!$A$3:$A$9),"1/07/2009")*(Sheet1!$B$3:$B$9<"31")
=SUMPRODUCT((Sheet1!$A$3:$A$9),"1/07/2009")*(Sheet1!$B$3:$B$9<"31")