How to use excel statistical data

After entering data in excel, statistics are needed. At this time, you need to use the COUNTIF function for statistics. Next, I will show you how to use Excel statistics. I hope it works for you.

How to use excel statistical data;

Method (1)

Statistical data step 1: directly enter the formula =COUNTIF(C2:C8, "& gt=60") in the cell, and double quotation marks must be entered in English. If it is only a single value, you don't need double quotation marks, just enter the value directly.

Method (2)

Statistical steps 1: menu bar? Formula (version 03 can be found in the data)? Other functions? Statistics? COUNTIF. A dialog box will pop up.