Try accumulating with =SUM(A1:A14)

The Sum function ignores non-numerics.

--

perfection Wrote:
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?


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532871