Excel i want to sum only numeric values except alphabetic values

[Solved/Closed]
Report
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012
-
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012
-
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

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
use SUM function
=SUM(D6,F6,H6,L6,P6 )
2
Thank you

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

CCM 2821 users have said thank you to us this month

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

thanks a lot