How does Excel implement automatic counting in another column?

<>count(c:c)

Or. counta(c:c)-1

Or. Convert Column A date format to Excel recognizable date by columnization.

countifs(a:a,">="&date(2020,8,1),a:a,"<="&date(202,9,0),c:c,"<>")

Or. countifs(a:a,">="&date(2020,8,1),a:a,"<="&date(202,9,0))

Or. countifs(a:a,">="&date(2020,8,1),a:a,"<"&date(202,9,1))

If you are not mistaken, you should enter the formula in cell i5:

sumifs(c:c,a:a,">=8",a:a,"<9"Enter the formula in j5:

countifs(a:a,">=8",a:a,"<9") to get the total amount and the total number of registrations for August, respectively.

There's a big problem with your ** data entry:First, the date should not be such a data, but should be entered into a format like 2020-7-25, which is the standard date format, and you can learn to use Excel

Second, the month column must be a standard data value, not an irregular name like you.

The third is the need for a standardized classification structure, generally you will do several categories in this operation, but the category names of the left and right ** must be consistent, so that it is easy to use the above two functions to classify and count in time periods.

How is your amount calculated, the same principle is the number of consumptions, the amount is used by the sumifs function, and the number of consumption transactions is used by the countifs function.

How are the first strokes calculated? I can't tell why it's 60 in the information on the graph, and I can't write a formula.

1. Select cell B1, press CTRL+F3, "Custom Name" and "Expression", and enter =, !a1) OK and complete the custom name;

2. Enter the following formula in cell B1, and then fill down the formula =len(expression)-len(substitute(expression,"+",""))+1

The formula means: the expression in a1 is obtained from the macro table function, and then the number of + signs is calculated, and 1 is added to add how many numbers are added.

3. When you're done, save the workbook as "Macro-enabled Workbook".