Formula assistance with multiple conditions

Hello all, 

I’m creating a large sheet to keep track of a high volume of input data that needs to be collected, and categorized, and then subsequently displayed in a simplistic manner for executive level reporting. I’m currently having trouble with my formula that I need to use to display a set of ten (10) numbers categorized from greatest to least. Think sales, I want my highest ticket on top, then followed by my next nine highest. My formula I am currently using is as follow: 

=LARGE(IF(OR((November!Mx:Mx<>”Y”),(November!Hx:Hx<>”No”)),November!Gx:Gx),ROW(N$59:N59))

[“x” next to the column identifier is filled with an array, but for simplicity sake, I am excluding actual ranges]

This formula is resulting in an incorrect data display as the corresponding “November!Hx:Hx<>”No”” is listed as No, but it is still displaying the information. If I replace the OR function with AND, I get the #Num error. 

For context, I am pulling data from one sheet to another (i.e. I am using this formula to pull data entered into the November sheet into the executive level “Total” sheet.)
Additionally, I want these to pull automatically, I want someone else who is using this sheet to be able to still retrieve the totals without having to do the added work of locating the top ten numbers manually. 
Additionally, I need two conditions met. The formula must check that the item is both not voided (hence the “<>”Y””) and must check that the item is actually invoiced (hence the “<>”No””). The conditions must remain in some capacity to ensure the data is accurate. 

Please let me know if I can explain anything further, I have been trying to locate a method of resolving this to no avail. Any assistance is greatly appreciated!