Sumif function of excel is one of most useful function if used properly. Let’s use sumif function to add cells which are not blank. Let’s say we want to add up those cells which are sold Through Agent Without Agent… Continue Reading →
Having difficult time understanding Index and Match functions? Here is the complete step by step guide with 9 practical example of Index and Match function.