SUMPRODUCT Function Sum The Return Value Of True And False. True = 1 And False = 0. So As Per This Example The Inner Function Which Will Return Canada As True Then SUMPRODUCT Will Add The Value Next To It Then It Will Find Next True And Will Add The Value Next To It And So On.
ISNumber Function Check Whether The Value Is Numeric Or Not And Return True Or False.
SEARCH Function Search The Cell For A Given Search Criteria And Return The Start Position OF Character.
