Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
relative vs complet reference
the folowing function
function sumrange(r as range,c) dim c as variant for each c in r if c0 then sumrange = c/worksheetfunction.sum(r) sumrange= format(sumrange,"##,##.00") next c end function is an attempt to calulate for each cell in a range ,the ratio between the cell & the total value of the range. my question- how can i program the function to create absolute reference to the range i choose,without using the f4 button. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
relative vs complet reference
I don't see your logic here because the code you have written is not
workable. If you just want to know the proportional value of the whole it does not matter if the range contains zeros or not. It would be different if you wanted an average to exclude zero values. There would seem to be no need to make a custom function because your need would be covered by copying down the column something like :- =A1/SUM($A$1:$A$10) Regards BrianB ================================================== ========== "moshe" wrote in message ... the folowing function function sumrange(r as range,c) dim c as variant for each c in r if c0 then sumrange = c/worksheetfunction.sum(r) sumrange= format(sumrange,"##,##.00") next c end function is an attempt to calulate for each cell in a range ,the ratio between the cell & the total value of the range. my question- how can i program the function to create absolute reference to the range i choose,without using the f4 button. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Reference help | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Auto complet is checked | Excel Worksheet Functions | |||
Relative Reference | Excel Discussion (Misc queries) | |||
Relative reference | Excel Worksheet Functions |