My Lotus function:

@DSUM($LSTDETAIL,"MTG",@LEFT(ACCOUNT,3)="QEA"#AND# #NOT#ACCOUNT="QEAX")

My failed Excel function


=SUMIF(LSTDETAIL,"MTG",LEFT(ACCOUNT,3)="QEA"#AND## NOT#ACCOUNT="QEAX")

The criteria section beginning with "QEA" becomes highlighted.

LSTDETAIL is a range.
MTG is a column heading
I want to sum up the amounts in the MTG column for which the first
3 left characters are QEA and all characters are not QEAX in the
LSTDETAIL range.

Any help will be appreciated.

Thanks,

Harvey
Providence, RI