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
Excel Is Simple is an attempt to help people understand the basics of MS Excel. After all excel is not a demon that many have promoted it as. Week on week we will try to help you with this application, the usage, formula and resolve the queries that people might have