Here is a simple explanation of the various COUNT and IF formulas Here are some of the simple COUNT and IF formulas: COUNT - Counts number of cells with numbers in a range COUNTA - Counts number of non blank cells in a range COUNTBLANK - Counts number of blank cells in a range COUNTIF - Counts if a criteria is met in a range COUNTIFS - Counts if multiple criteria is met in a range SUM - Sum of a range SUMIF - Sum of a range if a single criteria is met SUMIFS - Sum of a range if multiple criteria are met Watch the video to understand the working of these formulas Welcome to Excel is Simple; A channel where we will help you will all your excel problems in the simplest possible way Subscribe to the channel by clicking http://www.youtube.com/user/excelissimple?sub_confirmation=1
Comments
Post a Comment