Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
hi there is problem
i have some bata in sheet1 from a1 to a240 i want the the sum of a range of these values in the cell b2 of sheet2. but the start and end of the range i specify in cells a1 n a2 of sheet2 that is if sheet2 cells a1=2 and a2=210 then b2 of sheet2 must contain the sum of values from a2 to a210 of sheet1. how do i formulate this sum formula where the data of one cell is a part of the address of another cell kindly help thankin in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
linked cell is displaying formula instead of the data | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
formula to extract specific data if match occurs | Excel Worksheet Functions | |||
Formula for copying data for every 8th cell | Setting up and Configuration of Excel | |||
Formula to Extract Data from a Table | Excel Worksheet Functions |