Excel i want to sum only numeric values except alphabetic values [Solved/Closed]

Posts
10
Registration date
Wednesday October 10, 2012
Last seen
October 22, 2012
- - Latest reply: soni17177
Posts
10
Registration date
Wednesday October 10, 2012
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

See more 

2 replies

Best answer
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
2
Thank you
use SUM function
=SUM(D6,F6,H6,L6,P6 )

Say "Thank you" 2

A few words of thanks would be greatly appreciated. Add comment

CCM has helped 2904 users this month

Posts
10
Registration date
Wednesday October 10, 2012
Last seen
October 22, 2012
0
Thank you
thanks a lot