Re: My results don't appear in the cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thank you Max!! That worked. The spreadsheet was a template the worked
before I started adding columns. I will remember this trick for the future!!

"Max" wrote:

> I'm not sure if the expression
> =SUM(IF(ISTEXT(C6:AE6),0.5,0))
> was meant to be array-entered
> (Press CTRL+SHIFT+ENTER)
> which then seems to work as intended ??
>
> > That was more fun than pulling teeth.
> ROTFL! I've got only a set of dentures, btw.
> No need to pull, just take out / wash / put back. <bg>
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
>
>
>
.

Relevant Pages

  • Migrating a list from one site to another
    ... template with content. ... spreadsheet then recreate the list from the spreadsheet on the other site, ... but then I need to recreate all my views. ... Prev by Date: ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: My results dont appear in the cell
    ... Rgds ... The spreadsheet was a template the worked ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Import data to Back End from the Front End
    ... I want to import data into our back end database and link it to the front ... The trick is to do it from the front end via a form. ... I want the end user to be able to import a spreadsheet into the back end ... Prev by Date: ...
    (microsoft.public.access.externaldata)
  • Auto Update
    ... I have a spreadsheet that we are using for balancing reports ... On the spreadsheet I have columns for previous data. ... my template and just place the data on the template as previous? ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • RE: VLOOKUP and sum
    ... I was hoping to set up spreadsheet ... so all i would have to do is copy/paste the project# and sales ... columns from each month into the template spreadsheet.... ... Prev by Date: ...
    (microsoft.public.excel.misc)