Woopssssss...
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 <shujaa...@gmail.com> 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 D1
> 10 =val(C1)
> =val(C2)
>
> and so on.
>
> and simply take the sum of Column D.
>
> hope it helps.
> Best regards,
>
> M. Shujaat Ali
> Functional Consultant
> Focus Software Solutions Co. Ltd.
> Al-Khozaim Building, Office # 201
> Al-Khobar - K.S.A.
> Off: +966 3 8650491-92
> Fax +966 3 8643534
> Web:www.focussoftnet.com
>
> On Sat, Jul 31, 2010 at 11:32 AM, zp18 <irvinep...@gmail.com> 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" cell that would allow excel
>> to treat it as zero but not have a bunch of zeroes all over the
>> worksheet? Isnumber() works but I would have to have a test on each
>> individual cell.
>>
>> I normally use things like: if(isnumber(e35),e35+e40,"") so the
>> cell is blank until someone enters something numeric in the test
>> cell. I have also used if(isnumber(e35),e35+e40,) but this puts a
>> zero in the cell. Sometimes I have used Count in a range. Using
>> 'Clear Contents" doesn't seem to work either, but putting the cursor
>> in a cell and using delete seems to work OK, not sure why but I guess
>> I could write a macro to clear the worksheet ready for entry by
>> 'deleting' every entry.
>>
>> I did write a macro which clears the data entry area, but all formulas
>> are not functioning without testing incoming cells:
>>
>> Range("F6:H6,D11:F12,D17:F18,D23:F24,D29:F30").Select ' the four
>> pumps
>> Selection.ClearContents
>>
>> Range("D35:G37").Select
>> Selection.ClearContents
>>
>> etc
>>
>> This has plagued me for years and I know there must be a simple
>> answer. In the past I made some kind of workaround for a specific
>> spreadsheet and went on. I would really like to know what is the
>> accepted way to fill a cell so it shows blank but does not cause a
>> Value errror when used in a formula somewhere else.
>>
>>
>> Anyhow, I would appreciate any insight from anyone.
>>
>> TIA, zp18
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
