Try this:

=SUMPRODUCT(--(Roster!$E$2:$E$646=DATE(2007,7,1)),--(Roster!$E$2:$E$646<=DATE(2008,6,30)),--(Roster!$C$2:$C$646=B8),--(Roster!$H$2:$H$646="Non-Exp"))


--
Biff
Microsoft Excel MVP


"jbressma" wrote in message
...
I currently have this formula in a spreadsheet:

=SUMPRODUCT(--(YEAR(Roster!$E$2:$E$646)=2007), --(Roster!$C$2:$C$646=B8),
--(Roster!$H$2:$H$646="Non-Exp"))

Essentially it counts data based on three criteria, the first being if the
data includes a date in 2007.

My company changed from a fiscal year to a calendar year. Is there a way
I
can modify the above formula to go from counting if a date included "2007"
to
counting if a date included July 1, 2007 - June 30, 2008????