Excel i want to sum only numeric values except alphabetic values [Solved/Closed]
soni1717710
Posts Wednesday October 10, 2012Registration date
October 22, 2012
Last seen
-
Oct 21, 2012 at 04:31 PM - Latest reply: soni1717710
Posts Wednesday October 10, 2012Registration date
October 22, 2012
Last seen
- Oct 22, 2012 at 02:20 PM
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
has helped 1258 users this month