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

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: http://www.excelforum.com/member.php...o&userid=33486
View this thread: http://www.excelforum.com/showthread...hreadid=532871

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

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


"perfection" wrote
in message ...

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:
http://www.excelforum.com/member.php...o&userid=33486
View this thread: http://www.excelforum.com/showthread...hreadid=532871

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

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