Application.WorksheetFuntion.SumIfs

akbarnikain · Nov 28th 2017

As per the attached Workbook "VB MultipleCriteria-Ozgrid"
When I use the excel formula in Cell "F8" =SUM(SUMIFS(Qty,product,"="&F1, supplier,"=" & F2:F4,delDate,">=" & F5)) I get correct result.
How can I do the same in Cell "F6" using "Application.WorksheetFunction.SumIfs.... based on multiple CRITERIA in COLUMN "F" in VBA

Thanks

**Carim** · Nov 28th 2017

Hello,

You are dealing with an Array Formula ...

So your formula in F8

Code

[B]=SUM(SUMIFS(Qty,product,"="&F1, supplier,"=" & F2:F4,delDate,">=" & F5))[/B]

can be replicated with the following instruction in VBA :

Code

[F18].FormulaArray = "=SUM(SUMIFS(Qty,product,""=""&R[-7]C, supplier,""="" & R[-6]C:R[-4]C,delDate,"">="" & R[-3]C))"

Hope this will help

Application.WorksheetFuntion.SumIfs

Participate now!

Share