As per the attached Workbook "VB MultipleCriteria-2" I have an array formula in cell "F8"; viz.
=(SUM(SUMIFS(Qty,product,"="&F1,supplier,"="&F2:F4,delDate,">="&F5)))
Whenever, there is a change in cells "F1:F5" my vba code displays the result in cells "F6" & "F10" however, cell "F8" does not; unless i use "F9" to refresh it.
What is wrong in my formula in cell "F8"...hope someone has an answer.
Thanks