Based on your sample data:

=SUMPRODUCT(--(--RIGHT(A2:A5,4)<2000),B2:B5)

--
Biff
Microsoft Excel MVP


"Karina" wrote in message
...
Hi,

I'm trying to SUMIF data in "data" column with the condition that last 4
characters of "condition" column match certain criteria. For example, I
have:
Column A Column B
01-1000 5
02-1001 7
01-1002 6
02-2000 10
and I would like to sum data in column B if last 4 digits of data in
column
A is less then 2000. If everything done right, answer should be 5+7+6=18.
Any
suggestions?