multiple criteria ranges

Hi, I am trying to divide the result of one sumifs() statement by the result of another sumifs() statement, but the sum range and criteria ranges referenced in the second statement are not working.The ranges are valid but they are not highlighted in the sheet and the formula returns an error...

Hi Experts Please help I am an office 365 user and I need suggestions on what formula to use for this scenario. I have quite large data sets so I need the most efficient formulas that will not crash my workbook (+-30000 rows 69 columns). Scenario I need to be able to determine if a person...

Hi there, I am looking to extract max and min values from an array containing several thousands of records in the following format: <tbody> A B C D Year 1 1 0 8 2017 7 3 1 3 2017 9 6 2 4 2017 3 8 3 2 2017 9 9 4 7 2017 5 0 5 8 2018 4 1 6 9 2018 5 4 7 0 2019 </tbody> On a...

Hello, Very simply, there are sections of my data I want to exclude in my Max- and Min-If statements, but these sections are not continuous. These formulas work for excluding all account numbers less than 9700000...