is it possible to make excel not process non-numeric cell data in formulae

P

perfection

Let us imagine i have 14 marks to add of a studnt but i have had to
mark absent for one or more of these - our rukle says to mark AB in
such cell
Now i have to add up on the marks i will get an error because of the
non-numeric data in one or more cells

Right now we are processing with zero and a comment inserted which is a
bit more time consuming - any way out?
 
Top