You don't need anything more complicated than the SUMIF function:
=SUMIF(Sheet1!A$1:A$2500,Sheet2!A1,Sheet1!F$1:F$25 00)
where Sheet2!A1 holds the item description you want to get a tally for. The formula assumes data on Sheet1 rows 1-2500.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|