| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range of a function
How can I calculate a function for a certain range such as
Range from cell 50 to the last cell I tried this but not work Average(A50:A) Need your help Daniel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range of a function
Hi Daniel:
We don't need to know where the last cell is !! =AVERAGE(A50:A65536) is o.k. because AVERAGE ignores all the blank cells below the last used cell. -- Gary''s Student - gsnu200745 "Daniel" wrote: How can I calculate a function for a certain range such as Range from cell 50 to the last cell I tried this but not work Average(A50:A) Need your help Daniel |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range of a function
Thanks Gary'student
Yes it's work but other better way than (A50:A65536) ? Daniel "Gary''s Student" wrote: Hi Daniel: We don't need to know where the last cell is !! =AVERAGE(A50:A65536) is o.k. because AVERAGE ignores all the blank cells below the last used cell. -- Gary''s Student - gsnu200745 "Daniel" wrote: How can I calculate a function for a certain range such as Range from cell 50 to the last cell I tried this but not work Average(A50:A) Need your help Daniel |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Range of a function
Hi Daniel,
You can use a named range and call it Range1 or whatever then the formula would be =AVERAGE(Range1) To name a range just select the range of cells then click in the Name Box and type the name and hit enter The Name box is just to the left of the formula bar it usually displays the address of the active cell. See Help for more details. HTH Martin "Daniel" wrote in message ... Thanks Gary'student Yes it's work but other better way than (A50:A65536) ? Daniel "Gary''s Student" wrote: Hi Daniel: We don't need to know where the last cell is !! =AVERAGE(A50:A65536) is o.k. because AVERAGE ignores all the blank cells below the last used cell. -- Gary''s Student - gsnu200745 "Daniel" wrote: How can I calculate a function for a certain range such as Range from cell 50 to the last cell I tried this but not work Average(A50:A) Need your help Daniel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DBSUM function but with function as criterion, not a range | Excel Worksheet Functions | |||
| range function | Excel Discussion (Misc queries) | |||
| Use of range in an if function | Excel Worksheet Functions | |||
| How do I set up a range within a IF function? | Excel Worksheet Functions | |||
| Range function | Excel Worksheet Functions | |||
Linear Mode
