| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
complex excel formula Array how do I convert it to a vba Function
I have an Array Formula:{=SUM(IF((B2:B7="New") * (D2:D7="Test1")*(A2:A7="Band
A"),C2:C7*E2:E7)) + SUM(IF((B2:B7="New") * (F2:F7="Test1")*(A2:A7="Band A"),C2:C7*G2:G7))} in a cell, I have managed to alter this for use in VBA to change variables eg """ & Var & """ but want to do it as a WorksheetFunction so I don't have to add the formula to cells to get the answer. thank you for any help you can give. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function or formula to convert "text" month to number of month | Excel Discussion (Misc queries) | |||
| Excel should have a formula to convert number into words | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| Excel: Add "dBm" and "dBW" to CONVERT worksheet function Power u. | Excel Worksheet Functions | |||
Threaded Mode
