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.