A better option might be to those dates into 2 cells and then just reference
the cells instead of hardcoding them into the formula like that. It's then
obvious at a glance as to what thye parameters of the query are.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Dave F" wrote in message
...
Wow, that's great, thanks.

I ended up using the following:
=SUMPRODUCT(--(D13:D166=DATE(2006,7,1)),--(D13:D166<=DATE(2006,7,31)),(J13:J166))

Thanks.

Dave
--
Brevity is the soul of wit.


"Toppers" wrote:


=SUMPRODUCT(--(D2:D100=StartDate),--(D2:D100<=End date),(J2:J100))

where start/End dates are cells containing these values.

If you want to sum a calendar month e.g August:

=SUMPRODUCT(--(MONTH(D2:D100)=8),J2:J100)

HTH

"Dave F" wrote:

I have a data table whose columns are arranged in the following manner,
from
left to right:

Date | ArriveTime | LeaveTime |Hours | Overtime | Regular | Gross |
RunningGross | CumHours | $/Week

What I'm looking to do is sum the "Gross" column based on a period of
dates,
say 8/1/06 through 8/31/06, and not select this range manually.

The Date column is column D and the Gross column is column J.

Ideas?
--
Brevity is the soul of wit.