Message-ID:

7 May, 2024: fms is rebuilding. Don't expect much in that section for quite a few days, maybe longer.

devel / comp.lang.xharbour / Re: excel: syntax for using a dynamic variable in SUM

excel: syntax for using a dynamic variable in SUM

<011705d2-41f0-4736-baf5-22aa5c349916n@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=17043&group=comp.lang.xharbour#17043

copy link Newsgroups: comp.lang.xharbour

X-Received: by 2002:a05:6214:1c8c:b0:473:408f:ddd6 with SMTP id ib12-20020a0562141c8c00b00473408fddd6mr20896098qvb.74.1658142456410;
Mon, 18 Jul 2022 04:07:36 -0700 (PDT)
X-Received: by 2002:ae9:ec12:0:b0:6ac:665e:1dd8 with SMTP id
h18-20020ae9ec12000000b006ac665e1dd8mr16820039qkg.636.1658142456225; Mon, 18
Jul 2022 04:07:36 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Mon, 18 Jul 2022 04:07:35 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=74.102.138.144; posting-account=jZAeNwoAAABYWjMRM-FfqKkHfC3Iph0l
NNTP-Posting-Host: 74.102.138.144
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <011705d2-41f0-4736-baf5-22aa5c349916n@googlegroups.com>
Subject: excel: syntax for using a dynamic variable in SUM
From: timecosting@gmail.com (timepro timesheet)
Injection-Date: Mon, 18 Jul 2022 11:07:36 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 4

by: timepro timesheet - Mon, 18 Jul 2022 11:07 UTC

Re: excel: syntax for using a dynamic variable in SUM

<e47094bb-bd40-478e-8249-c8f94e853b6en@googlegroups.com>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=17058&group=comp.lang.xharbour#17058

copy link Newsgroups: comp.lang.xharbour

X-Received: by 2002:a05:620a:f12:b0:6b6:64e9:260c with SMTP id v18-20020a05620a0f1200b006b664e9260cmr22288698qkl.538.1660173600169;
Wed, 10 Aug 2022 16:20:00 -0700 (PDT)
X-Received: by 2002:a0d:c2c1:0:b0:31d:6b53:bc02 with SMTP id
e184-20020a0dc2c1000000b0031d6b53bc02mr30828392ywd.402.1660173599915; Wed, 10
Aug 2022 16:19:59 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!1.us.feeder.erje.net!feeder.erje.net!border-1.nntp.ord.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Wed, 10 Aug 2022 16:19:59 -0700 (PDT)
In-Reply-To: <011705d2-41f0-4736-baf5-22aa5c349916n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=220.240.222.118; posting-account=zx0oKAkAAABMkjQR74hmeFvHN7cev7io
NNTP-Posting-Host: 220.240.222.118
References: <011705d2-41f0-4736-baf5-22aa5c349916n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <e47094bb-bd40-478e-8249-c8f94e853b6en@googlegroups.com>
Subject: Re: excel: syntax for using a dynamic variable in SUM
From: lawrence.edelstein@gmail.com (poopall)
Injection-Date: Wed, 10 Aug 2022 23:20:00 +0000
Content-Type: text/plain; charset="UTF-8"
Lines: 7

by: poopall - Wed, 10 Aug 2022 23:19 UTC

On Monday, 18 July 2022 at 9:07:37 pm UTC+10, timec...@gmail.com wrote:
> *how to syntax a dynamic variable (THETAXPERC) in 'sum'
> for jc=nstart to xrow
> xvar1="P"+alltrim(str(jc));xvar2="Q"+alltrim(str(jc))
> oSheet:cells(jc,21):value="=sum("+xvar1+"+"+xvar2+"/"+THETAXPERC")"
> next

Can you send a small example of the spreadsheet you are using

Subject	Author
excel: syntax for using a dynamic variable in SUM	timepro timesheet
Re: excel: syntax for using a dynamic variable in SUM	poopall