• Hello,

    You are dealing with an Array Formula ...

    So your formula in F8

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

    can be replicated with the following instruction in VBA :

    [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!