Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My problem is this. The following formula:
=(('Budget MRS 2007'!$H6*'Budget MRS 2007'!$H7)+('Budget MRS 2007'!$I6*'Budget MRS 2007'!$I7)+('Budget MRS 2007'!$J6*'Budget MRS 2007'!$J7)+('Budget MRS 2007'!$K6*'Budget MRS 2007'!$K7)+('Budget MRS 2007'!$L6*'Budget MRS 2007'!$L7)+('Budget MRS 2007'!$M6*'Budget MRS 2007'!$M7))/I6 Is extracting data from one sheet "Budget MRS 2007" and returning a result. But I need to use this formula to calculate a lot of data. The above formula e.g. use cell H6-M6 and H7-M7 but I need results for H11-M11 and H12-M12 and so forth it increases with 5 cells everytime. Is there a smart way that I can make a formula or something, so that I don't have to manually change the cellnumbers that excel needs to extract data from, but make excel realize that it need to take 5 cell steps every time. Hope this makes any sence or else dont hesitate to write back for further explanation. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to extract data from table in other worksheet | Excel Discussion (Misc queries) | |||
Extract data from one worksheet | Excel Worksheet Functions | |||
Using a column of data from 1 worksheet to extract data from another worksheet | Excel Worksheet Functions | |||
Extract data from one Worksheet to another | Excel Worksheet Functions | |||
extract data from worksheet | Excel Worksheet Functions |