Using SUMIF with RIGHT()
 

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?

Using SUMIF with RIGHT()
 

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


"Karina" wrote:

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?

Using SUMIF with RIGHT()
 

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?

Using SUMIF with RIGHT()
 

Perfect, thank you so much!!!

"John C" wrote:

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


"Karina" wrote:

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?

Using SUMIF with RIGHT()
 

Perfect, thank you so much!

"T. Valko" wrote:

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?

Using SUMIF with RIGHT()
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Karina" wrote in message
...
Perfect, thank you so much!

"T. Valko" wrote:

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?