Excel i want to sum only numeric values except alphabetic values
Solved/Closed
soni17177
soni17177
- Posts
- 10
- Registration date
- Wednesday October 10, 2012
- Status
- Member
- Last seen
- October 22, 2012
soni17177
- Posts
- 10
- Registration date
- Wednesday October 10, 2012
- Status
- Member
- Last seen
- October 22, 2012
Related:
- Excel i want to sum only numeric values except alphabetic values
- How to convert numerical values into words in excel - Guide
- Excel - Macro to highlight Rows with Duplicate values in a cell ✓ - Forum - Excel
- Excel vba save worksheet as new file values only ✓ - Forum - Excel
- Excel conditional formatting if sum of cells is greater than ✓ - Forum - Excel
- Count all cells in a given range that contain only numeric values - Forum - Excel
2 replies
rizvisa1
Oct 21, 2012 at 05:28 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Oct 21, 2012 at 05:28 PM
use SUM function
=SUM(D6,F6,H6,L6,P6 )
=SUM(D6,F6,H6,L6,P6 )
soni17177
Oct 22, 2012 at 02:20 PM
- Posts
- 10
- Registration date
- Wednesday October 10, 2012
- Status
- Member
- Last seen
- October 22, 2012
Oct 22, 2012 at 02:20 PM
thanks a lot