Using SUMIF with RIGHT()

K

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unhide column difficulty 3
If Function 1
IF ARRAY with multiple conditions. 1
SUMIF with criteria "<>" & "=" 4
Problem using IF statement with dates as part of the formula 4
Modifying a complex date formual to count months 4
VLOOKUP or SUMIF for Multiple Criteria 2
how to sum with this table 9

Top