IF, COUNTIF, SUMIF Functions in Excel
Today We’ll be learning about one of the most important functions in excel IF, COUNTIF, SUMIF.
- 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)
2. COUNTIF Function
This function is used to Count a particular condition and defined as:
=COUNTIF(Range Of Things To Count,Criteria To Match)
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)
Keep visiting Analytics Tuts for more tips and tricks.