Hämta formelargument från en annan cell?

Rogis

New Member
Joined
Oct 26, 2005
Messages
6
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
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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
ABCDEF
166F1E11155
Sheet2
 
Upvote 0
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
 
Upvote 0
I don't know where the heck Fairwinds has wandered off to...

Ever heard of summer holliday? :diablo:

You know, sailing, swimming, drinking beer... 8-)
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. :-D
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,226,730
Messages
6,192,708
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top