Looking for Text strings
 

I lost all my data and have to redo my home spreadsheet, but It's been awhile
since I made it and I have forgotten some of my formulas. I need a simple one
tho. On my input page column A I list the amounts. In column B I use a text
code for the vender i.e.

Column A Column B
$42.00 WM
$59.00 SW

Now what I need is the formula that will place the amount on my data sheet
depending on the "WM" or "SW" text codes like so.

Wal-mart Safeway
$42.00 $59.00

I had my last workbook set up this way but I haven't worked with formulas in
a long time and my mind isn't as sharp as it once was. Thanks in advance for
the help.

Looking for Text strings
 

Additional example data might be helpful, but my first guess would be that
you want to use the SUMIF function.

--
Best Regards,

Luke M
"Scats" wrote in message
...
I lost all my data and have to redo my home spreadsheet, but It's been
awhile
since I made it and I have forgotten some of my formulas. I need a simple
one
tho. On my input page column A I list the amounts. In column B I use a
text
code for the vender i.e.

Column A Column B
$42.00 WM
$59.00 SW

Now what I need is the formula that will place the amount on my data sheet
depending on the "WM" or "SW" text codes like so.

Wal-mart Safeway
$42.00 $59.00

I had my last workbook set up this way but I haven't worked with formulas
in
a long time and my mind isn't as sharp as it once was. Thanks in advance
for
the help.

Looking for Text strings
 

Luke is correct. Your formula might look like this:

for Safeway:

SUMIF(B2:B19,"sw",A2:A19)

"Luke M" wrote:

Additional example data might be helpful, but my first guess would be that
you want to use the SUMIF function.

--
Best Regards,

Luke M
"Scats" wrote in message
...
I lost all my data and have to redo my home spreadsheet, but It's been
awhile
since I made it and I have forgotten some of my formulas. I need a simple
one
tho. On my input page column A I list the amounts. In column B I use a
text
code for the vender i.e.

Column A Column B
$42.00 WM
$59.00 SW

Now what I need is the formula that will place the amount on my data sheet
depending on the "WM" or "SW" text codes like so.

Wal-mart Safeway
$42.00 $59.00

I had my last workbook set up this way but I haven't worked with formulas
in
a long time and my mind isn't as sharp as it once was. Thanks in advance
for
the help.


.

Looking for Text strings
 

That helps a lot. That's what I was looking for almost. I wanted it to look
for certain letters and put the amount in the right cells. But with this
formula if it doesn't find the code then it leaves a $0.00. How do I get it
to just leave the cell empty if that certain code isn't there.

"petedacook" wrote:

Luke is correct. Your formula might look like this:

for Safeway:

SUMIF(B2:B19,"sw",A2:A19)

"Luke M" wrote:

Additional example data might be helpful, but my first guess would be that
you want to use the SUMIF function.

--
Best Regards,

Luke M
"Scats" wrote in message
...
I lost all my data and have to redo my home spreadsheet, but It's been
awhile
since I made it and I have forgotten some of my formulas. I need a simple
one
tho. On my input page column A I list the amounts. In column B I use a
text
code for the vender i.e.

Column A Column B
$42.00 WM
$59.00 SW

Now what I need is the formula that will place the amount on my data sheet
depending on the "WM" or "SW" text codes like so.

Wal-mart Safeway
$42.00 $59.00

I had my last workbook set up this way but I haven't worked with formulas
in
a long time and my mind isn't as sharp as it once was. Thanks in advance
for
the help.


.