IF, COUNTIF, SUMIF Functions in Excel

Today We’ll be learning about one of the most important functions in excel IF, COUNTIF, SUMIF.

  1. IF Function

One of most important and most used function in formula. This function is defined as:

 =IF(Condition,Value If True,Value If False)

IF

2. COUNTIF Function

This function is used to Count a particular condition and defined as:

=COUNTIF(Range Of Things To Count,Criteria To Match)

COUNTIF

 

3. SUMIF Function

This function is used to calculate using some condition and it defined as:

=SUMIF(Range Of Values To Check, Values to Match, Range of Values To Total)

 

SUMIF

Keep visiting Analytics Tuts for more tips and tricks.

Leave a Reply

Your email address will not be published. Required fields are marked *