Add numbers in cells that also contain text

Add numbers in cells that also contain text

I use Excel 2007 for my grading record.
It works fine for adding a set (column) of scores when the only items in cells are numbers.
But if I add a text label (L standing for a Late submission, for example) the score number doesn't get added into the total.
In other words, the SUM formula ignores any cells with letters.
How can I modify the formula so that it includes numbers in cells that also contain a text item?

Anwsers to the Problem Add numbers in cells that also contain text

Download SmartPCFixer to Fix It (Free)

You can use a "special" format for cells that will display the L, but still be manipulated arithmetically:
right-click a cell > Format Cells...
> Number > Custom > General" L"

gsnu201005

Make Sure that your System Meets the System Requirements

You need to double-check your computer's hardware configuration against the following Microsoft requirements. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:

Microsoft Windows Requirements :

• 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
• 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

Another Safe way to Fix the Problem: Add numbers in cells that also contain text:

How to Fix Add numbers in cells that also contain text with SmartPCFixer?

1. Download Error Fixer . Install it on your system.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed

Related: [Solved] Applications have stopped working with SP1 on Windows 7!,[Solved] I can't find auto complete text in word 2007,[Solution] I need to keep reinstalling eHome Infrared Transceiver driver everytime my computer shuts down.,How to Resolve - system restore not working windows 7?,Unable to open embedded word file on the intranet. [Solved],Solution to Error: Error: "0x81000032 make sure the C: drive is online and set to NTFS" when trying to backup to external hard drive.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,I'm always being signed off so annoying Tech Support
,Solution to Problem: Impossible to use Internet Explorer! I keep getting the same error message every time i try to use IE.
,Solution to Problem: Referencing data in another file
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: Solution to Error: Add and remove programs won't respond,[Anwsered] A friend updated to Win 7,Tech Support: A problem caused RealPlay.exe to stop interacting with Windows.,Fast Solution to Error: Add Number and their Sum?,How to Resolve - Accessing an XP backup on a portable hard drive attached to a windows 7 computer.?,Cannot delete empty file icon on desktop...,Cannot download flashplayer,can't get the CIA review progrom install which is an older version,Cannot access one website-DNS server not responding.,Can't Receive or Send Vista Windows Mail - Router stopped recognizing DSL connection & wants to dial up