Technical info

  Purpose of IF Function A test which output is only one either true or false. Syntax of IF Function =IF (logical_test, [value_if_true], [value_if_false]) Step 01                                                                                                         Step 02                                                                                                              Step 03

Attendance Sheet in Excel  

  HOW TO DO MERGE CELL FUNCTION IN EXCEL Select Required Cells Select Merge & Center Results

HOW TO SUM IN EXCEL SUM FORMULA PRACTICAL  

  FORMULA                 =CONUTIF (range, criteria) How to use the =COUNTIF function: Select a cell. Type =COUNTIF. Double click the COUNTIF command. Select a range. Type , Select a cell (the criteria, the value that you want to count) Hit enter. Practical of COUNT IF: it is use to count the cell and intire cell data with same nature it can be numbers alphabets etc some practical overviews are below mentioned.

Sum Formula in Excel =SUM (Select Cell Range) =SUM (B1:B12)   You can see this topic videos on my facebook page and also on my You Tube chanel  FACEBOOK LINK https://fb.watch/jEWUF5YuqP/  https://youtu.be/JvGV4x--fhc