rand can't seem to handle
> non-numeric inputs, whereas the SUM function has a built-in ability to
> ignore them.
> Regards - Dave.
>
> ------
> Date: Sat, 31 Jul 2010 22:42:34 -0700
> Subject: Re: $$Excel-Macros$$ Arithmetic with blank cells
>
> Fro
, 31 Jul 2010 22:42:34 -0700
Subject: Re: $$Excel-Macros$$ Arithmetic with blank cells
From: irvinep...@gmail.com
To: excel-macros@googlegroups.com
OK, here is an example: The whole idea is to prevent a data entry spreadsheet
having a bunch of zeroes in all the totalizing columns. Cells K1,L1 and K2,L
Woopss...
Sorry for in-complete formula:
keep the formula as =if(C1="",0,C1)
regards,
On Sun, Aug 1, 2010 at 8:39 AM, Shujaat Ali wrote:
> Hey,
>
> soemthing i would use, simple and easy, if its fits :)
>
> simply take another (any) column with the formula of Val , for example:
>
> C1
OK, here is an example: The whole idea is to prevent a data entry
spreadsheet having a bunch of zeroes in all the totalizing columns. Cells
K1,L1 and K2,L2 have been "Clear Contents", Cell M3 the totalizer cell is
blank. Put a 1 in K1 and the #Value error appears in M3
Cell M1: =
Hey,
soemthing i would use, simple and easy, if its fits :)
simply take another (any) column with the formula of Val , for example:
C1D1
10 =val(C1)
=val(C2)
and so on.
and simply take the sum of Column D.
hope it helps.
Best regards,
M. Shujaat Ali
Fu
if u try to uncheck zero values from tools option zero value
On Sat, Jul 31, 2010 at 2:02 PM, zp18 wrote:
> I have a bunch of cells that may or may not have numbers in them.
>
> Kind of like this: Sum(e35:e44) , but with no number in e44, I get the
> #Value error. What should be in a "empty" cel
Hi,
When I use SUM on a range of cells that may or may not be numeric, I don't get
a value error. Blank cells seem to be treated as zeros, and text cells are
ignored. I use xl2003. But perhaps I'm not understanding correctly. Could you
attach a sample workbook?
Regards - Dave
> Date: Sat, 3
