| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with formula/doesn't pull data with slash (/)
Hi,
I was wondering whether someone could give me a hand with this formula, or whats wrong with this formula: =sumif('Parts&Product Numbers'!D$3:D$500,Stock!A32,'Parts&Product numbers'!E$3:E$500) The formula works, but it doesnt pull the information i want in column e (at the end of the formula). In column E i have three variables: 8400 8500/8550 8400/8500/8550 the formula only returns the 8400 variable, it doesn't seem to like the / , or any other form of punctuation. Please could someone tell me how it can return these variables with their attached /. thank you Greg. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Pasting Data | Setting up and Configuration of Excel | |||
| How can I pull data from multiple user workbooks into one? | Excel Discussion (Misc queries) | |||
| Referencing multiple criteria to pull data | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Chart/Source Data update problem | Charts and Charting in Excel | |||
Threaded Mode
