Forum Discussion
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 executi...
=IFERROR(LARGE(IF((November!$M$2:$M$20<>"Y")*(November!$H$2:$H$20<>"No"),November!$G$2:$G$20),ROW(A1)),"")
You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
Sheet "Total"
Sheet "November"