Lookup Formula Needed
 

Here is what I need the formula to do: I will have two columns, Column A
will have a value and Column B will have a code. I want to Sum the numbers
in Column A IF the Code in Column B has the letter "R" in it. So, using
the data below, my formula would add the values 100+400+500 from column A
and return a result of 1,000. Any help would be appreciated!

Column A Column B
100 R1
200 M3
400 R2
500 R6
700 I1
300 M3

Lookup Formula Needed
 

Try this:

=SUMIF(B:B,"*R*",A:A)

The asterisk is a wildcard character, so it will match on anything
with R in it. If you only want to match on a code beginning with R you
could have "R*" instead.

Hope this helps.

Pete

On Jan 22, 6:26*pm, sweetmans
wrote:
Here is what I need the formula to do: * * I will have two columns, Column A
will have a value and Column B will have a code. *I want to Sum the numbers
in Column A *IF the Code in Column B has the letter "R" in it. * * *So, using
the data below, my formula would add the values 100+400+500 *from column A
and return a result of 1,000. * * * Any help would be appreciated!

Column A * * Column B
100 * * * * * * * * *R1
200 * * * * * *M3
400 * * * * * *R2
500 * * * * * *R6
700 * * * * * * I1
300 * * * * * * M3

Lookup Formula Needed
 

Thanks very much! This does exactly what I need it to do!


"מיכאל (מיקי) אבידן" wrote:

If the "R" is always the left most character - try this:
=SUMPRODUCT((LEFT(B1:B6)="R")*(A1:A6))
Micky


"sweetmans" wrote:

Here is what I need the formula to do: I will have two columns, Column A
will have a value and Column B will have a code. I want to Sum the numbers
in Column A IF the Code in Column B has the letter "R" in it. So, using
the data below, my formula would add the values 100+400+500 from column A
and return a result of 1,000. Any help would be appreciated!

Column A Column B
100 R1
200 M3
400 R2
500 R6
700 I1
300 M3