I'm trying to sum the values when B:B = J2 AND C:C = K2 AND row 3:3 >= L2 AND row 3:3 is < M2
CodePudding user response：
Using Query is probably overkill for what you're trying to do. You can use SumProduct for something like this or when doing a 
I'm trying to sum the values when B:B = J2 AND C:C = K2 AND row 3:3 >= L2 AND row 3:3 is < M2
CodePudding user response：
Using Query is probably overkill for what you're trying to do. You can use SumProduct for something like this or when doing a