Sal,

This assumes on sheet 1 we have

Col A = Names
Col B = values to sum
Col C = dates

On sheet 2
C1 = early (start) date
D1 = later (End) date

=SUMPRODUCT((A1=Sheet1!A:A)*(Sheet1!C:C=C1)*(Shee t1!C:C<=D1)*(Sheet1!B:B))

Note that while you can use full columns if you can I would shorten the
ranges to speed things up a bit
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sal" wrote:

Perfect Mike, thank you so much. I would like to add another part to that
equation. My entries are also listed by date. Is it possible to add to that
equation to include a certain date range?

Sal

"Mike H" wrote:

Sal,

Try this on sheet 2

=SUMPRODUCT((A1=Sheet1!A:A)*(Sheet1!B:B))

drag down as required
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sal" wrote:

I have a spreadsheet with several thousand entries. On one sheet, call it
sheet 1, there is One column with about 100 names, another column has number
amounts. My other sheet, call it sheet 2, has a list of names. What I would
like to do is for each name on sheet 2, sum up the number values from sheet
one for that particular name. So the end result would be a column on sheet
two that shows the totals taken from sheet 1 for each name. I keep adding new
entries on sheet one, so the totals on sheet 2 must always show the updated
totals. Any help would be greatly appreciated. I am using office 2007.