Prev: Dynamically Create and ID OptionButtons, then insert Row; Loop
Next: Adding a decimal place
From: Mia on 7 May 2010 10:39
Hi,

I'm trying to make a summary in a specified tabell without
have to specifie what start and end cell. So far I have done like this

SUMMA.OMF(Januari!$C$4:$C$92;Januari!$A$4:$A$92;"=x")

but I want something like this

Summa.omf(Januari[#Allt] etc....
so that I can specifie column and tablename.

I hope someone knows howe to do this.


--
Best regards
Mia
From: Wouter HM on 7 May 2010 12:02
Hi Mia,

I do not re ognize which language version you using.

try:

SUMMA.OMF(Januari!$C:$C;Januari!$A:$A;"=x")

HTH,

Wouter


From: Mia on 10 May 2010 02:45
Hi,

Thank you so much for your help, it worked!

I'm using swedish.


--
Best regards
Mia


"Wouter HM" wrote:

> Hi Mia,
>
> I do not re ognize which language version you using.
>
> try:
>
> SUMMA.OMF(Januari!$C:$C;Januari!$A:$A;"=x")
>
> HTH,
>
> Wouter
>
>
> .
>
 | 
Pages: 1
Prev: Dynamically Create and ID OptionButtons, then insert Row; Loop
Next: Adding a decimal place