ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I use SUM in a user defined function procedure? (https://www.excelbanter.com/excel-programming/371207-how-can-i-use-sum-user-defined-function-procedure.html)

John

How can I use SUM in a user defined function procedure?
 
can anyone help me find a way to make this function work?

Function test(value, value1, value2)
test = Sum(value, value1, value2)
End Function

(I don't really want to write a UDF to do exactly what a SUM does, but would
like to use a SUM in my function)

tx


Die_Another_Day

How can I use SUM in a user defined function procedure?
 
test = Application.Sum(value, value1, value2)

HTH

Charles

John wrote:
can anyone help me find a way to make this function work?

Function test(value, value1, value2)
test = Sum(value, value1, value2)
End Function

(I don't really want to write a UDF to do exactly what a SUM does, but would
like to use a SUM in my function)

tx



Dave Peterson

How can I use SUM in a user defined function procedure?
 
test = application.sum(....)



John wrote:

can anyone help me find a way to make this function work?

Function test(value, value1, value2)
test = Sum(value, value1, value2)
End Function

(I don't really want to write a UDF to do exactly what a SUM does, but would
like to use a SUM in my function)

tx


--

Dave Peterson


All times are GMT +1. The time now is 12:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com