Hi Martin

(leaving aside the whole lotus vs excel question)

if i have the following values
........A.............B
1....ABC123...5
2....ABC.........5

and use the formula
=SUMIF(A1:A2,"ABC",B1:B2)
i end up with the answer of 5

so i'm not sure what you mean in your post about SUMIF matching ABC and
ABC123?

Cheers
JulieD


"Martin" wrote in message
...
I have read several messages in this group about the problem with DSUM and
matching the criteria values in that a criteria of "ABC" also matches
"ABC123".

Based on suggestions in the group, I tried using the SUMIF statements.
But,
lo and behold, the same problem surfaces! Apparantly, Excel just plain
cannot tell the difference in values.

I agree with some other postings that the Lotus functions are MUCH more
flexible and useful. In fact, the ONLY reason I am attempting Excel is
because of a company standard.

Because of the volume of work we do that requires accurate criteria
matching, I would definitely use Lotus over Excel. This problem makes
Excel
useless for us. If I could, I would recommend that our company use Lotus.