Hämta formelargument från en annan cell?

[Rogis]

Jag gör en summering med SUMMA(a:b). Går det att ersätta "a" resp "b" med innehållet i en annan cell?
Ex.vis om formeln finns i cell A1 så ska "a" motsvara innehållet i cell B1 (t.ex. F5) och "b" motsvara innehållet i cell C1 t.ex. E5.

mvh/Frank

 

[Greg Truby]

I don't know where the heck Fairwinds has wandered off to... with the help of a translating website that Fairwinds was not impressed with... I'll make an attempt. I think you're asking about how to use the INDIRECT() function, in which case it would be something like...

book2
	A	B	C	D	E	F
1	66	F1	E1		11	55
Sheet2

 

[Rogis]

I don't know where the heck Fairwinds has wandered off to... with the help of a translating website that Fairwinds was not impressed with... I'll make an attempt. I think you're asking about how to use the INDIRECT() function, in which case it would be something like...

Well Greg, your translating website can't be working too bad .. :wink:
Your solution was exactly what I was looking for, works fine. Thanks!

Rgds
Frank

 

[fairwinds]

I don't know where the heck Fairwinds has wandered off to...

Ever heard of summer holliday?

You know, sailing, swimming, drinking beer...
NOT sitting in front of a computer.

I'll be out on the ocean for two more weeks now. Then I might consider popping in here again.

 

[RAM]

I don't know where the heck Fairwinds has wandered off to... with the help of a translating website that Fairwinds was not impressed with... I'll make an attempt. I think you're asking about how to use the INDIRECT() function, in which case it would be something like...

What's the Website, Greg?

RAM

 

[Greg Truby]

http://www.systranbox.com/systran/box

It's the only one I've come across that handles Swedish. If anyone knows of a better one, I'd love to learn of it. [Though the only place I ever need Swedish is here.]

 

[RAM]

Thanks Greg,

I think I agree with Fairwinds

If anyone knows of a better one, I'd love to learn of it.

Me too.

RAM