software

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?--
perfection
------------------------------------------------------------------------
perfection's Profile: www.excelforum.com/member.php...oamp;userid=33486
View this thread: www.excelforum.com/showthread...hreadid=532871If 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
quot;It is a good thing to follow the first law of holes;
if you are in one stop digging.quot; Lord Healeyquot;perfectionquot; gt; wrote
in message news
gt;
gt; Let us imagine i have 14 marks to add of a student but i have had to
gt; mark absent for one or more of these - our rule says to mark AB in
gt; such cell (to distinguish it from a zero which is nil marks obtained
gt; for a studnt who was present)
gt;
gt; Now i have to add up on the marks i will get an error because of the
gt; non-numeric data in one (or more) cell(s)
gt;
gt; Right now we are processing with zero and a comment inserted which is a
gt;
gt; bit more time consuming - any way out?
gt;
gt;
gt; --
gt; perfection
gt; ------------------------------------------------------------------------
gt; perfection's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33486
gt; View this thread: www.excelforum.com/showthread...hreadid=532871
gt;

Try accumulating with =SUM(A1:A14)

The Sum function ignores non-numerics.

--

perfection Wrote:
gt; Let us imagine i have 14 marks to add of a student but i have had to
gt; mark absent for one or more of these - our rule says to mark AB in
gt; such cell (to distinguish it from a zero which is nil marks obtained
gt; for a studnt who was present)
gt;
gt; Now i have to add up on the marks i will get an error because of the
gt; non-numeric data in one (or more) cell(s)
gt;
gt; Right now we are processing with zero and a comment inserted which is a
gt;
gt; bit more time consuming - any way out?--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=532871