Previous Topic Next Topic

Excel i want to sum only numeric values except alphabetic values

Solved/Closed
soni17177 Posts 10 Registration date Wednesday October 10, 2012 Status Member Last seen October 22, 2012 - Oct 21, 2012 at 04:31 PM
soni17177 Posts 10 Registration date Wednesday October 10, 2012 Status Member 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

Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 21, 2012 at 05:28 PM
use SUM function
=SUM(D6,F6,H6,L6,P6 )
Answer 2 / 2
soni17177 Posts 10 Registration date Wednesday October 10, 2012 Status Member Last seen October 22, 2012
Oct 22, 2012 at 02:20 PM
thanks a lot

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Name Values
brendanconlin -
TrowaD -

1 response
Excel function question
1234ah -
ac3mark -

3 responses