Thanks:  0
Likes:  0

# Thread: Offset--a beginning question

1. Not realy understand when to use Offset function and how to use it, special when combine another function with offset, such as "=sum(offset(rng1, 0, rng2-1)", what does Offset really mean? Thanks a lot

2. On 2002-04-29 13:28, WYTT wrote:
Not realy understand when to use Offset function and how to use it, special when combine another function with offset, such as "=sum(offset(rng1, 0, rng2-1)", what does Offset really mean? Thanks a lot
Did you have a look in Excel's Help file? It's pretty good exposed.

And what is rng1 and rng2 in the formula you mention?

3. Read Excel Help of Offset function a couple of times, but still have a problem to apply it! in what kind of circumstance should use it? also how to combine offset with other functions?

Rng1 and Rng2 is defined name of two datas. The name can be changed base on your perference.

4. On 2002-04-29 14:05, WYTT wrote:
Read Excel Help of Offset function a couple of times, but still have a problem to apply it! in what kind of circumstance should use it? also how to combine offset with other functions?

Rng1 and Rng2 is defined name of two datas. The name can be changed base on your perference.
The OFFSET worksheet function has lots of uses. One particular use is constructing dynamic name ranges and similarly when you want to apply functions to ranges that change. I use it a lot myself. See a contrib of mine at

http://www.mrexcel.com/board/viewtop...c=6611&forum=2

BTW, You didn't tell what rng1 and rng2 stand for!

5. Thanks a lot.
Rng1 is named for "product range", Rng2 for "choice range". Sorry not clarify it last post

Read your link, it is very helpful. Ask a stupid question, the formula that you used is:

=sum(offset(\$B\$2, match(d2, A:A, 0)-e1-1, 0,E1, 1)

Why \$B\$2 not \$B\$1? What is \$B\$1 and \$B\$2?

Thanks a bunch!!!!!

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•