Application.WorksheetFuntion.SumIfs

  • 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

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!