Is it possible to make excel NOT process non-numeric cell data in formulae

[perfection]

Let us imagine i have 14 marks to add of a student but i have had to
mark absent for one or more of these - our rule says to mark AB in
such cell (to distinguish it from a zero which is nil marks obtained
for a studnt who was present)

Now i have to add up on the marks i will get an error because of the
non-numeric data in one (or more) cell(s)

Right now we are processing with zero and a comment inserted which is a

bit more time consuming - any way out?

 

[Peo Sjobom]

If you use sum instead of cell1+cell2 you won't get any errors since sum
ignores text

=SUM(B2:B15)

not

=B2+B3+B4 etc

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Nothwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Bryan Hessey]

Try accumulating with =SUM(A1:A14)

The Sum function ignores non-numerics.

--