Remember Me?

#1
July 25th 11, 04:16 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2011 Posts: 8
Row references

I have the following columns.

A B C D
1 1 6 D1
2 7 23 D2
3 24 31 D3
4 32 38 D4
5 39 44 D5
etc.

Columns B and C refer to the row numbers on another worksheet.
D1-D5 are array formulas. I want D1 = FUNCTION(sheet1!A1:A6). D2 =
FUNCTION(sheet1!A7:A23). D3=FUNCTION(sheet1!A24:A31). You get the
idea. Function could be sum, average, whatever that has an array
reference.

How do you do this? I hope there is an easy way of incorporating

Jeff

#2
July 25th 11, 11:30 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2010 Posts: 1,045
Row references

On Sun, 24 Jul 2011 20:16:10 -0700 (PDT), jeffrey wrote:

I have the following columns.

A B C D
1 1 6 D1
2 7 23 D2
3 24 31 D3
4 32 38 D4
5 39 44 D5
etc.

Columns B and C refer to the row numbers on another worksheet.
D1-D5 are array formulas. I want D1 = FUNCTION(sheet1!A1:A6). D2 =
FUNCTION(sheet1!A7:A23). D3=FUNCTION(sheet1!A24:A31). You get the
idea. Function could be sum, average, whatever that has an array
reference.

How do you do this? I hope there is an easy way of incorporating

Jeff

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Dima Excel Discussion (Misc queries) 6 August 8th 08 12:38 PM Dima Excel Worksheet Functions 6 August 8th 08 12:38 PM Dave F[_2_] Excel Discussion (Misc queries) 1 May 15th 08 04:43 PM Vulcan Excel Worksheet Functions 3 December 13th 07 11:43 PM Abbas Excel Discussion (Misc queries) 1 May 24th 06 06:18 PM

All times are GMT +1. The time now is 10:27 AM.