Groups | Search | Server Info | Login | Register

Groups > comp.sys.acorn.misc > #6277

Re: Eureka spreadsheet question.

Show all headers | View raw

In article <52c8e00831dave@triffid.co.uk>,
   Dave Symes <dave@triffid.co.uk> wrote:
> In article <50431e66$0$289$14726298@news.sunsite.dk>,
>    Alex Macfarlane Smith <nospam@archifishal.co.uk> wrote:
> > On 02/09/2012 06:35, Dave Symes wrote:
> > [snippity]

[Snippy]

> > > My brains is pudding from messing with this...
> > >
> > > D.
> > >

> > If you want to do what I think you want to do, then this seems to work:

> > https://dl.dropbox.com/u/30539430/ExcelFile.xls

> > J6  =(SUM($I$6:I6))
> > J7  =(SUM($I$6:I7))
> > J8  =(SUM($I$6:I8))

> > I think the problem with what you were trying was that you were
> > effectively creating a string (by adding the ':' in the middle), so
> > the formatting you had on the cell had no effect.

> > Alex.

> Thanks for that Alex,
> In theory your solution would work, but for some reason I can't fathom it
> is not producing the correct totals.

> I'm going to contact the friend (Sheet owner) and ask if its' okay for me
> to put up a bigger sample of the actual sheet.

> Thanks
> Dave

I have  his okay.

I've prepared the sheet with an extra column illustrating the problem
using your formula Alex.

New archive with both EurSheet and Excel sheet are at:

http://www.triffid.co.uk/dstuff/Sheets2.zip


Thanks on behalf of my friend.
Dave

-- 

Dave Triffid

Back to comp.sys.acorn.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-01 18:41 +0100
  Re: Eureka spreadsheet question. spampling <spam.pling@btinternet.com> - 2012-09-01 22:05 +0100
    Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-02 06:35 +0100
      Re: Eureka spreadsheet question. Alex Macfarlane Smith <nospam@archifishal.co.uk> - 2012-09-02 09:52 +0100
        Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-02 12:33 +0100
          Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-02 12:51 +0100
            Re: Eureka spreadsheet question. Alex Macfarlane Smith <nospam@archifishal.co.uk> - 2012-09-02 13:07 +0100
              Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-02 14:33 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-02 18:36 +0100
                Re: Eureka spreadsheet question. "Derek.Moody" <derek.moody@casterbridge.net> - 2012-09-03 00:07 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-03 06:20 +0100
                Re: Eureka spreadsheet question. Chris Evans <chris@cjemicros.co.uk> - 2012-09-03 13:06 +0100
                Re: Eureka spreadsheet question. "Derek.Moody" <derek.moody@casterbridge.net> - 2012-09-03 19:02 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-04 06:09 +0100
      Re: Eureka spreadsheet question. Tony Moore <old_coaster@yahoo.co.uk> - 2012-09-02 11:36 +0000
  Re: Eureka spreadsheet question. John Bryan <john@bryan86.fsnet.co.uk> - 2012-09-04 14:23 +0100
    Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-09-04 18:48 +0100
      Re: Eureka spreadsheet question. "Derek.Moody" <derek.moody@casterbridge.net> - 2012-09-06 00:21 +0100

csiph-web