Previous Topic Next Topic

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

Answer 1 / 2
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
Thank you

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

CCM 2821 users have said thank you to us this month

Answer 2 / 2
Posts
10
Registration date
Wednesday October 10, 2012
Status
Member
Last seen
October 22, 2012
thanks a lot
Ask a question