Hi, morning everybody
Looking help the formula of Sumproduct ( not sure it's work or not) wanna base on the certain criteria to find the average result.
example
criteria at sheet1 B2
fine the range at sheet2 E2 to down if meet the criteria at sheet1 B2 than average the all value at B2 to down.
please help or if sumproduct are not suitable which please to advised.