thanks a lot,
it works great.

maileen.

Bob Phillips wrote:
=SUMIF(Sheet1!A1:A100,"Total",Sheet1!D1:D100)