Tag Archives: WorksheetFunction.SumIf

SUMIF From VBA

There are three ways we can be involved with SUMIF() when we are using VBA. The Range.Formula(), Range.FormulaR1C1() and Range.FormulaArray() Properties This is a straightforward process. To enter a formula containing SUMIF() we use the Range.Formula or Range.FormulaR1C1 properties: If … Continue reading

Posted in Microsoft Excel, Microsoft Office | Tagged , , , , , , , , | Leave a comment