Web Development, Software Development, Mescius Doc Solutions, Csharp, Excel.
second parameter is a boolean array of conditions. In our case, we are looking for the “North” region in D4:D13; that is, the value of this parameter should be D4:D13=”North” If_empty — This parameter returns a specified value when no entries meet the criteria. We set it to “No Record Found” Below