Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup and text strings | Excel Discussion (Misc queries) | |||
Sorting different strings of text | New Users to Excel | |||
Matching Two Text Strings to see if Like | Excel Worksheet Functions | |||
Separating Text strings. | Excel Discussion (Misc queries) | |||
Text Strings Conversion | Excel Worksheet Functions |