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
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