Excel i want to sum only numeric values except alphabetic values

Solved/Closed

soni17177

Posts: 10
Registration date: Wednesday October 10, 2012
Status: Member
Last seen: October 22, 2012

- Oct 21, 2012 at 04:31 PM
soni17177

Posts: 10
Registration date: Wednesday October 10, 2012
Status: Member
Last seen: October 22, 2012

- Oct 22, 2012 at 02:20 PM

Hello,

in a school resultsheet where each student having numeric values of their marks in 5 subjects.i am using formula =D6+F6+H6+L6+P6 for total obtained marks of each student but if a student not appeared in the exam of 2nd subject then I am putting there AB in F6 cell after it excel not showing the total marks according to formula but showing the message #VALUE!
please help me to correct it

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

Answer 1 / 2

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

770
Oct 21, 2012 at 05:28 PM

use SUM function
=SUM(D6,F6,H6,L6,P6 )

Answer 2 / 2

soni17177

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

Subscribe To Our Newsletter!