Using SUMIF with RIGHT()

[Karina]

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?

 

[John C]

=SUMPRODUCT(--(RIGHT(A2:A100,4)<"2000"),(B2:B100))

 

[T. Valko]

Based on your sample data:

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

 

[Karina]

Perfect, thank you so much!!!

=SUMPRODUCT(--(RIGHT(A2:A100,4)<"2000"),(B2:B100))

 

[Karina]

Perfect, thank you so much!

Based on your sample data:

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

 

[T. Valko]

You're welcome. Thanks for the feedback!