Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to repeatly use some complicated array functions.
For example, this function which calculates conditional sums and only returns a value if it is positive: =IF(SUM(IF(From=$E3,IF(To=H$1,Cost,0),0))-SUM(IF(From=H$1,IF(To=$E3,Cost,0),0))<0,"",SUM(IF( From=$E3,IF(To=H$1,Cost,0),0))-SUM(IF(From=H$1,IF(To=$E3,Cost,0),0))) Of course, after I enter this formula I have to hit Ctrl + Shift + Enter Is there a way to convert this into a user defined function like: Public Function ConditionalSum(Column1Values, Column2Values, Column3Values) ... ... End Function -- Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User Defined Functions | Excel Discussion (Misc queries) | |||
User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
excel functions and User defined functions | Excel Programming | |||
Array as Argument in User-Defined Functions | Excel Programming | |||
Array as Argument in User-Defined Functions | Excel Programming |