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

soni17177 10 Posts Wednesday October 10, 2012Registration date October 22, 2012 Last seen - Oct 21, 2012 at 04:31 PM - Latest reply: soni17177 10 Posts Wednesday October 10, 2012Registration date October 22, 2012 Last seen
- 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
rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Oct 21, 2012 at 05:28 PM
2
Thank you
use SUM function
=SUM(D6,F6,H6,L6,P6 )

Thank you, rizvisa1 2

Something to say? Add comment

CCM has helped 1258 users this month

soni17177 10 Posts Wednesday October 10, 2012Registration date October 22, 2012 Last seen - Oct 22, 2012 at 02:20 PM
0
Thank you
thanks a lot