I have one additional question if it's not too much.

I am trying to sum the money associated with these date ranges now- the
values are found in column F of the Data worksheet. I have put this formula
into cell J4 of the Data worksheet (the date ranges are still found in A4 for
start, B4 for end), and I have hit a snag. Do you see anything obvious I am
missing?

=SUM(IF(Data!$A$2:$A$2000=A4,IF(Data!$A$2:$A$92<B 4,Data!$F$2:$F$92,0),0))

"Max" wrote:

Welcome, Gina. The feedback is appreciated.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Gina" wrote in message
...
Max, this is exactly what I needed. I really appreciate your help, and
have
located a tutorial on sumproduct, and plan to study this for the rest of
the
day.

Thank you so much,

Gina