Previous Topic Next Topic

Excel i want to sum only numeric values except alphabetic values

Solved/Closed
soni17177 Posts 10 Registration date Wednesday 10 October 2012 Status Member Last seen 22 October 2012 - 21 Oct 2012 à 16:31
soni17177 Posts 10 Registration date Wednesday 10 October 2012 Status Member Last seen 22 October 2012 - 22 Oct 2012 à 14:20
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

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

Similar discussions

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

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
Excel function question
1234ah -
ac3mark -

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

20 responses