Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble
Strawberry Orange Banana Lime Leaf Slate Sky Blueberry Grape Watermelon Chocolate Marble

MSFN is made available via donations, subscriptions and advertising revenue. The use of ad-blocking software hurts the site. Please disable ad-blocking software or set an exception for MSFN. Alternatively, register and become a site sponsor/subscriber and ads will be disabled automatically.

# kbdavis

Member

10

\$0.00

0 Neutral

## Profile Information

• OS
Windows 7 x64
1. ## SUM function with complications. Need help with formula.

That worked Perfectly! Thank you very much. I did make a very slight modification to the formula mentioned, using =SUMIF(A:A,"ABC100",B: B) That helped out a lot!
2. ## SUM function with complications. Need help with formula.

Let's see if anyone out there could help me out with this problem... Let's say I was needing to sum up the total in column B.. Easy enough, huh? Well, if it were only that simple (which I am sure it is for most of the people reading this or I wouldn't be here). Let's say the only cells in column B i wanted to add up were cells that contained a specific "Client Code" in column A. Example: | A | B || ABC100 | \$500.00 || ZZZ900 | \$100.00 || ABC100 | \$200.00 || XYZ350 | \$ 50.00 |I am needing it to automatically add up all the #s in "B" that has the client code of ABC100. So that would be B1,B3, and to ignore the rest. Is there a formula that would allow me to do this? Thanks in advance!

BUMP
4. ## How to keep number formats when you "hard return" in a single

I am using excel 2010, and was wondering if it is possible to create a custom format for phone #'s in excel that will allow me to put two phone numbers in a single cell, separated by a "hard enter" (ALT + ENTER), thus formatting two entirely separate phone numbers. Example: 5551234567 9875554321 which would automatically format to: (555) 123-4567 (987) 555-4321 The code block above represents one single cell. ### edited to show reasoning ### I am trying to automatically sort a bunch of information alphabetically, which is why I can only use one, single cell..

Ok here is the final product instructions, thanks to the help of CharlotteTheHarlot & Jumper for their contributions: Open up notepad, copy and paste this code: REGEDIT4 [-HKEY_CLASSES_ROOT\Directory\Shell\Print] [HKEY_CLASSES_ROOT\Directory\Shell\Print] @="&Print Directory" [HKEY_CLASSES_ROOT\Directory\Shell\Print\Command] @="\"C:\\Windows\\Printdir.bat\" \"%1\"" Name it anything as long as you change the extension from .txt to .reg Open the reg file you just created and apply the changes to the registry. Next In a new notepad, copy and paste this code: dir %1\*.* /a /ogn /-p > C:\Temp\Listing.txt C:\Windows\notepad.exe /p C:\Temp\Listing.txt cls Save this file as PrintDir.bat. This needs to be saved in your windows directory. Afterwards, I would restart your computer, mainly because I don't trust anything to get loaded in the memory (hence, the new registry change you just did). You can also try killing the explorer.exe process then starting it again. Again, the credit for this goes to CharlotteTheHarlot & jumper. I am just here to condense all the suggestions they gave to make this happen. Thanks again for the help, and hope this thread helps others who are needing to print a directory.

It works perfect. Thanks for the help and the speedy replies!

Thanks for the tip and the quick reply. The registry edit is working now. Now I have a new problem See the attached screenshot of the issue. We know that the registry tweak worked because it directed to the PrintDir.bat file and actually managed to open notepad as instructed. So, I believe my issue now lies in the instruction block of the PrintDir.bat file. Below I have put in the code of the file, and would like to know if you know a way to tweak this the proper way... @echo off dir %1 /-p /o:gn > “%temp%\Listing” start /w notepad /p “%temp%\Listing” del “%temp%\Listing” exit Thanks for all the help, we are getting somewhere now!

Please post the exact registry scripts you tried. Usually it is just a matter of getting the quotes and backslash characters "escaped" correctly. This just means using the proper syntax so that REGEDIT actually inserts the expected string into the registry. I attached a couple of screen shots to show you how I applied the registry edits.

I attempted this method, also using the other poster's method with the "folder" instead of directory, with no success. Any troubleshooting ideas? *By the way, thanks for the quick response for both posters! EDIT: Please note that your method may work, I just have limited knowledge of editing the registry and I may have made the error with the execution part.