| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change SUMIF formula into a vb code
Is it possible to change the formula below into a VB code?
=SUMIF($A$11:A18,A18,$D$11:D18)-SUMIF($A$11:A18,A18,$F$11:F18) -- ASU |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
change SUMIF formula into a vb code
ans=Evaluate("SUMIF($A$11:A18,A18,$D$11:D18)-SUMIF($A$11:A18,A18,$F$11:F18)"
) "ASU" wrote in message ... Is it possible to change the formula below into a VB code? =SUMIF($A$11:A18,A18,$D$11:D18)-SUMIF($A$11:A18,A18,$F$11:F18) -- ASU |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| formula or vba code | Excel Worksheet Functions | |||
| change the code to be a formula | Excel Discussion (Misc queries) | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
Linear Mode
