Excel Tip: SUM formula can be used to add Numbers in a Range containing both Numbers and Text.

If you want to add only the numbers in a range (e.g a column) you can simply use the SUM() formula for this range. The text will be ignored and the numbers will be added. 

Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD

Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com