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 →
Let’s say we want to sum if celll contain number i.e. adding those cells which are having sale amount of Less than $1000; Equal to $1000; & More than $1000 In following sales register (Pic1) Formula = Sumif (range, criteria,… Continue Reading →
Sum function of excel add the cells which are selected by cell reference, but what if I want to add the cells which meet the specific criteria. The criteria for adding up cells could be text, partial text, number etc…. Continue Reading →
Knowing all the functions of excel wouldn't make you productive but knowing where to use and how to use. So Kaival Patel created Simplified Excel to provide knowledge on how various functions of excel can be used for data analysis. Using the best option will not only save your time but your efforts also.