How to count the number of times it appears in Excel in a month?

1, open Excel, and open the Excel table that needs statistics.

2. Select the table content range, that is, all the ranges that need to be counted.

3. Select a blank cell and enter the formula =COUNTIF(A 1:D8, "Shanghai"). Click the check mark at the bottom of the toolbar in the figure to count its times.

4. Calculation result 8, you can count the number of occurrences in a month in Excel.

What is the most nutritious for leeks?

Icons-Illustrations of Traditional Chinese Medicine-Illustrations in 7 Styles

Who are the officials of the underworld under Yan Luowang?

How to make salty rice as home-cooked rice

Complete list of green vegetable names

Can duck be stewed with goldenrod rhizomes?

Is the Bureau of Retired Veteran Cadres in Beijing not good?

Is there anything delicious next to Xiamen Science and Technology Museum?

Practice of less water powder in Hechuan, Chongqing